Network Performance Dashboard

(Solana - July 14)

Introduction:

Solana is a public blockchain platform with smart contract functionality. Its native cryptocurrency is SOL. Solana achieves consensus using a proof-of-stake mechanism and a "proof-of-history" mechanism.

Like various other blockchains, Solana can run smart contracts.

This dashboard will investigate into Solana blockchain performance by checking its Transaction Per second (TPS), Success rate, failed transactions etc in current year.

Methodology:

To do this analysis I used

• Flipside Crypto database
• solana.core.fact_transactions table
• solana.core.fact_swaps table
• solana.core.fact_blocks table

Note: all of the analyses is since the beginning of 2022

\n \n

At first step lets check Solana TPS;

To calculate TPS I used daily time frame cuz of heavy data needed to explore in second or minute timeframes.

I calculate number of all transactions by counting TX_count in solana.core.fact_blockstable and finally grouping them by daily time frames I managed before by truncating my block_timstamp to day.

Anyway the visualized result is this beautiful bar chart.

As you see TPS is often about 3000 but has ups and downs in which im gonna talk about.

first TPS fall is for Jan 3, 2022 in which we see TPS going lower than 1000. Jan 7th we see a similar down again. These TPS decreasing are usually in just one day but on a period beginning from Jan 20 to Jan 23 we see TPS is lower than normal range for a relatively long time.

April 7 to 10 show this decrease too. (As in 1st and 20th of May).

Now lets get deeper and see are these TPS changes correlated with something or not :

The first thing I was eager to check was daily unique users work with Solana network.

Well Its so interesting to see that almost after every rise in users, we see a decrease in TPS.

Lets see deeper, for example look at May10 ( the day we see the user number goes up from 800k to 1.8 m), this huge number of users made network face problem organizing transactions and we see TPS decrease. May 25 is another example.

But only new users is the problem? Exactly no cuz we see days with huge increase in user numbers but no severe change in TPS like April 12.

So new users can make troubles for Solana but not only thing we should fear of!

Here I calculate Solana Success rate by joining to subqueries (by WITH) of successful transactions and all transaction.

We see that in the days of lowering TPS we have lowering success rate too, meaning more failed transactions as well. May 12 has the lowest success rate but when we check last charts we see no “huge” changes in users or TPS, so as I said for daily users, lowering TPS may lead to lowering success rate buy not always and vice versa (in other word, its a factor but not only factor)

I said about failed transactions, Lets check how these failed transactions affect users.

First lets find top wallets with highest fee paid for failed transactions (In other words paid for nothing!)

To achieve this goal, I used to count TX_ID with succeeded as false.

As you see, “Cuie…” paid more than 122 million gas ()Note that every lamport is 1/10e9 SOL and this wallet paid 0.122 SOL for Fee) and has the first place.

Other wallets can be seen in chart.

Now time to check Platforms!

I usedsolana.core.fact_swaps table and count failed tx_ids and finally grouping them by swap_program.

Jupiter DEX is on the first place and has more than 329m failed transaction since beginning of this year.

Other platforms can be seen as well.

> This analysis was created by MRFTI (Flipside, mrfti#7948 on Discord) on 14 July 2022 for Flipside Crypto's Solana Network Performance Dashboard Bounty".

Conclusion:

Solana TPS can decrease over invasion of new users.

Solana TPS decrease can decrease its Success rate too.