NEAR Performance

Questions :

> ### How does NEAR stock up to other L1s in terms of speed and performance? How fast is NEAR, and compare it with other blockchain speeds in terms of transactions per minute and percentage of transactions that fail.

Introductions :

> ### How fast is Near protocol? > > ### NEAR is indeed fast. It can handle up to 100,000 transactions per second (tps) and reaches transaction finality almost immediately owing to a 1-second block cadence." > > ### But let see its performance in chart with real data

Metods :

For this bounty we compared NEAR with other Layer 1 databases we have in Flipside in term of transaction speed and failed transactions in last month .

L1 databases we have in Flipside for now are NEAR , Ethereum , Solana , Flow , Avalanche , Algorand , Osmosis , Thorchain and BSC .

We used transaction table of this databases

> sql > SELECT date_trunc(DAY,BLOCK_TIMESTAMP), > COUNT(TXN_HASH)/1440 >

With this code we get daily average of transaction per minute for each L1 and put them together with using union function and seperate them by adding a column named mark to each

with getting average of information we acquired in above we can get monthly average

As you can see Solana have highest average of transaction per minute by a large margin to other L1 platforms, and NEAR is in sixth place with average of almost 246 transaction per minute in last month.

You can also see on the daily chart that Flow and BSC have had ups and downs in their transactions over the past month, but NEAR and other platforms have been stable.

Now let see what percent of this transaction was failed for each platform, for doing this we first select daily time stamp and count transactions where transaction status is failure and also get total transactions and after that we used below code

(failed_tx*100)/total_tx

and with getting average of information we acquired in above we can get monthly average percent of failed transactions

Althogh Solana have most of transactions it also have most percent of failed transactions in this Layer 1 platforms, and NEAR with about 17 percent failed transactions is in thirth place, and lowest failed transaction belong to Ethereum

As daily chart show us percent of failed transactions in Flow and Osmosis in last month was unstable but for NEAR and other platforms it was stable

We doesn't have Algorand failed transaction data in database table we used so Algorand is not in this comparison

Conclusion :

> ### although in theory NEAR has a huge speed but what we saw in chart show us NEAR still is not on par with other L1 platforms like Solana in term of transaction speed > > ### And its percent of failed transaction is also very much and after Solana and Osmosis, NEAR has highest failed transaction percent

Appendix :

> ###

> ### my discord : msafadoost #5494

flipside