Question

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?

Creation date: 2022-07-13

Created by piper

Methods

• Used timeframe 2022-01-01 till 2022-07-10
• Queried solana.core.fact_events and solana.core.fact_transactions

Introduction

What is Solana?

Solana is an open source, high-performance, permissionless blockchain.

=>

Failed and Successful Transactions

false = failed, true = successful

Solana Network Performance in TPS

Daily Usage (Users & Transactions)

SELECT block_timestamp::date AS date, COUNT(DISTINCT(signers)) AS number_of_users, COUNT(DISTINCT(tx_id)) AS number_of_transactions, number_of_transactions/number_of_users AS average_transactions_per_user FROM solana.core.fact_transactions WHERE block_timestamp::date BETWEEN '2022-01-01' AND '2022-07-10' AND succeeded = 'True' GROUP BY date

> I wanted to show the number of users and transactions from the beginning of the year til 2022-07-10, but because of the bad performance it was not possible to get results today :-(

This analysis was created on 2022–07–13 for a bounty at Flipside Crypto by piper to answer the following questions:

Solana - Network Performance Dashboard: 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?

All data used are from Flipside Crypto.

Conclusion

• Number of Transactions has increased and also success rate has increased in the last 2 month
• Transactions per Second (TPS) are increasing since April 9th, that means performance is getting better
• Number of Users & Transactions: Not possible to receive results from velocity :-(
• Botting: Not possible to receive results from velocity :-(
• Fees: Not possible to receive results from velocity :-(

Sorry for not finishing this dashboard …

Solanas performance is getting better these days and it is based on the good work of Solana engineers!!

Thanks for reading!

Failed and Successful Transactions

• The Number of Transactions is increasing since the beginning of the year.
• A clear increase in the number of transactions is visible, especially in the last two months.
• The current month, July, is the strongest month this year so far.
• With the increase of transactions also the number of failed transactions is increasing, which is also very visible in the past 2 month. But at the beginning of the year the number / percentage of failed was much higher.
• An increase in transactions / utilization therefore also means an increase in failed transactions.

=> It seems that the performance regarding successful Transactions (success rate) has increased.

TPS rate

• Beside some general network problems at the beginning of the year, the TPS were very high in the first three month.

• Since April the TPS rate was going down and had it low on April 9th (network failure). Since then the numbers are getting better and are now close to the top values from the beginning of the year.

  \

=> TPS rate is increasing => Performance is increasing!