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

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?

\n

Recent Solana Stability Updates:

Solana Releases New Updates to Reduce Bot Activity and Improve Network Stability

Solana suffered severe performance degradations on three different occasions in the last ten months necessitating the new features.

The problem was deemed to have been caused by performance bugs in the blockchain, specifically in the transaction processing unit (TPU). During those times when the system was down, the number of transactions processed per second dropped from thousands to just tens.

QUIC Protocol Will Be Implemented on the Solana Network.

To solve this problem, developers have attempted to stabilize operations around the platform’s existing user datagram protocol (UDP). Google’s QUIC protocol will replace UDP in the new update. This is to stop bots from sending an unlimited amount of traffic and starving the Solana pipeline from proposing transactions.

QUIC is an encrypted transport layer network designed to make HTTP traffic faster, more secure, and more efficient. The protocol is often used by applications and services that require fast online services.

Fee Prioritization Is Also Included in the New Update

Additionally, the upgrades will introduce a new-look fee prioritization model, which Solana hopes will mitigate the effect of popular applications and services.

Solana co-founder Anatoly Yakovenko took to Twitter on Wednesday to explain how the new features, especially the fee prioritization, will work after the network upgrades.

Solana’s architecture makes this new system possible because it can specify which part of the network it interacts with. On Solana, network validators will also be able to include a certain number of transactions for a specific account in each block and mark them as prioritized if extra fees are paid.

Methodology:

for this bounty, first I have calculated transactions per second for Solana on each day. i have calculated TPS is as the number of transactions per day divided by 86400. (24h * 60m * 60s).

Moreover, I have defined Solana bots in my own way. I think the users which more than 200 daily transactions done on Solana are bots and else are non-bots (Humans).

Considering the above facts, in this dashboard, I am going to:

• Analyze daily Solana transactions per second (for past month vs rest of the year)
• Analyze daily success rate of transactions on Solana (for past month vs rest of the year)
• Analyze daily number of bots and number of their transactions (for past month vs rest of the year)
• Analyze daily number of humans and their transactions (for past month vs rest of the year)
• Analyze daily paid fees in SOL for failed transactions on Solana (since start of the year 2022)
• check which wallets and programs have paid the most fee for failed transactions in Solana (since start of the year 2022)

Sources:

In the above chart, we can see transactions per second for Solana on each day since start of the year, divided into 2 types (past month vs rest of the year).

As we see, these numbers has increased on past month comparing to the timespan between April and early-June. least number of TPS has occured on 9th April and most number achived on Jan 2022.

On the above chart, we can see Success rate of transactions on Solana during the year 2022. as we see, the success rate has reached its lowest amount on May. but after that especially during past month, we can see a satisfying recovery in the success rate.

And in the above chart, we can see number of transactions made by Solana bots during the year 2022. we can see the activity on bots were decreasing till April 2022. but after that and especially during past month, we can see the increasing number of transactions by bots over time.

In the above chart, we can see number of Humans who are making transactions on Solana over time. we can see with ongoing of bearish market, the number of humans who are performing transactions on Solana is also decreasing over time. we can see most number of humans interacted with Solana transactions on May 2022 (during market heavy price crash), after that, a light decreasing trend is visible on the chart also over the past month.

And in the above chart, we can see number of transactions bade my Humans over time. as we see, this number has decreased dramatically over time especially during past month.

In the above chart, we can see the daily Paid fees for failed transactions on Solana (in SOL). as we see, the most paid Fee for these failed transactions have achieved on July 2022. least fee for these transactions was paid on April 2022. the trend was decreasing since start of the year till April 2022, but after that, we can see an increasing trend over time till today.

In the above chart, we can see Top 10 wallets who paid the most Fees (in SOL) for failed transactions on Solana. as we see, the wallet address 5AmZM5qY2LZtBMVSTVzyZmUGFCgiMTD9xaRuLF8XF1hK has paid the most fee, after that we have “CuieVDEDtLo7FypA9SbLM9saXFdb1dsshEkyErMqkRQq” and “Y2akr3bXHRsqyP1QJtbm9G9N88ZV4t1KfaFeDzKRTfr” on the next ranks.

In the above chart, we can see Top 10 programs who paid the most Fees (in SOL) for failed transactions on Solana. I have extracted their name using solana labels table.

As we see, the most paid fee for failed transactions was performed by Pyth Oracle. after that, we have serum dex v3 on the next rank.

On the above chart, we can see number of bots on Solana during the year 2022 (the users who made more than 200 daily transactions on Solana.) as we see, the number of these bots is increasing over time and also over past month.

Conclusion:

In this dashboard, we have realized:

• Solana ecosystem is recovering during past month in both terms of number of transactions and also success rate of them.
• We can see increasing number of bots and decreasing number of users using Solana ecosystem during past month.
• The wallet address 5AmZM5qY2LZtBMVSTVzyZmUGFCgiMTD9xaRuLF8XF1hK has paid the most fees on failed Solana transactions.
• Pyth oracle has paid the most Fees for failed transactions on Solana.

So, we can conclude that solana improvement during past month can be because of fewer users, because the number of bots were still increasing during past month.

Also, the updates from solana engineers (that i have mentioned above at the start of the dashboard), can be effective on this improvement too.