Questions :

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?

Introductions :

Solana (CRYPTO:SOL) is a blockchain platform known for its speed and efficiency. SOL tokens are its native cryptocurrency and are used to pay its transaction fees. Since launching in 2017, Solana has grown to become one of the largest cryptocurrencies in the world.

\n

Metods :

We used solana.core.fact_transactions table and solana.core.dim_labels table for this bounty . BLOCK_TIMESTAMP , TX_ID and SUCCEEDED are column we used from solana.core.fact_transactions table to acquire succes rate for transactions . And to acquire wallets and programs have paid the most in fees for failed transactions we used both tables mentioned before, joined them toghether, ON SIGNERS[0] = ADDRESS for wallets and ON INSTRUCTIONS[0]:programId::string = ADDRESS for programs .

As you can see, since May, the transaction per second starts to increase, but the daily users are less and the success rate is higher than May, so the success rate has a direct relationship with the number of transactions and an indirect relationship with the number of users.

Let see their relationships in charts.

In this two chart you can completely see relationship between transaction and success rate, and users and success rate .

But i think Solana engineers also made some improvements recently .

In next 2 charts we are going to see what wallets and programs have paid the most in fees for failed transactions .

Almost wallets that have paid the most in fees for failed transactions are from ftx hot wallets

pyth oracle , serum dex and jupiter also are programs have paid the most in fees for failed transactions.

Conclusion :

As we saw success rate has a direct relationship with the number of transactions and an indirect relationship with the number of users.

Almost wallets that have paid the most in fees for failed transactions are from ftx hot wallets, and pyth oracle , serum dex and jupiter also are programs have paid the most in fees for failed transactions.

Appendix :

my discord : msafadoost #5494