Question:

Q95. Create a dashboard displaying Solana network performance over time.

\n How has the network performed over the past month compared to the rest of the year? Has transaction per second and success rates of transactions gone up recently? Is this because of less botting or fewer users, or new improvements from the Solana engineers? What wallets and programs have paid the most in fees for failed transactions?

Overview of investigation:

Solana blockchain performance has been explored based on the TPS and success rare of transactions. Wants to find the parameters related to the performance of blockchain in the past 2 months.

Approach:

• TPS of blockchain

date_trunc('second',block_timestamp) seconds, count(tx_id) tps from Solana.fact_transactions where block_timestamp >= CURRENT_DATE-60

• Success rate or failure rate

  SUCCEEDED, count(distinct SIGNERS[0]) as users_solana, count(distinct tx_id) as txn_solana from flipside_prod_db.solana.fact_transactions

• Newcomers on Solana

  distinct SIGNERS[0]as sender, min(block_timestamp) as first_transaction_stamp from flipside_prod_db.solana.fact_transactions

• Protocols

  label, count(distinct tx_id) as no_txn from solana.core.fact_transactions t join solana.core.dim_labels l on t.instructions[0]:programId = l.address

Results:

Key findings:

1. The number of Solana users has not grown much, while the number of network transactions has increased.
2. The max TPS of blockchain has been risen in the considered time period.
3. The count of newcomers on Solana blockchain has been reduced considerably.
4. The area related to the failed transactions (shown by False) has been reduced and for that the area of succeeded transactions enhanced in the considered time pariod.
5. Top two wallets with on account ranking have over 40 million failed transactions.
6. Jupiter, Serum and switchboard are top 3 protocols with lots of failed transactions as question asked.