Introduction

Solana is a web-based blockchain that provides high speed, security and scalability for decentralized applications (DeFi). This network uses three consensus protocols to increase its efficiency. These protocols are Proof of Stake (PoS), Proof of History (PoH) and Proof of Replication (PoRep). The purpose of this work is to significantly increase the speed of transaction processing and increase security compared to the solutions used by other blockchains. In the Solana network, it is possible to perform 50,000 transactions per second. For this reason, this network is suitable for the parallel implementation of smart contracts or many decentralized applications.

Method

1. For Calculating daily TPS, I used the TX_COUNT column in solana.core.fact_blocks table. I totlize the TX count for every block in one day, then divide it by, 86400 (number of seconds in one day)

   \

2. for Failed TX rate, I used solana.core.fact_transactions table and count the failed transactions then divide it by count of total transactions

   \

3. number of unique user can be calculated with solana.core.fact_transactions table and signers column

Questions

1. How has the network performed over the past month compared to the rest of the year?
2. Has transaction per second and success rates of transactions gone up recently?

This graph show us:

1. in the last month, we can see the TPS grow day by day, and we had an ATH on Jul 10th

   \

2. if we compare the last month with the rest of the year, we can see fewer TPS drop in last month

This graph show us:

1. between Apr 3rd and Jun 13th there was a big amount of failed TX rate

   \

2. in the last month, the failed TX rate decrease and the performance of the network get better

This graph show us:

1. after a big jump in daily unique user, there was decreasing in count of users that used the network in the last month

Conclusion

If we compare last month with the rest of the year we can see improve in performance of the network and I think this because of the drop in daily unique address that used the network.

This graph show us :

1. here we can see the wallet that spent most fee on failed transaction