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. 

Methods

flipside_prod_db.mdao_near.transactions tables are used for all needed data for NEAR chain and also the following cods are applied for distinguish successful and failed transactions.

‘

CASE

WHEN TX_RECEIPT[0]:outcome:status LIKE '%Failure%' THEN 'FALSE'

WHEN TX_RECEIPT[0]:outcome:status LIKE '%Success%' THEN 'TRUE' END AS status

‘

For others chains transaction table are used.

Following chains are compare with NEAR

1. Ethereum
2. BSC
3. FLOW
4. POLYGON

The graphs show the average TPM for successful transactions from highest to lowest in the last 3 months in the following order:

1. polygon

2. Ethereum

3. Flow

4. BSC

5. NEAR

   and also show maximum TPM for failed transactions belong to the NEAR.

Pie charts show the percentage of failed transactions between all transactions exist in flipside tables

The percentage of failed transactions from best to worst is as follows

1. Ethereum 3.13%

2. BSC 6.48 %

3. FLOW 12.1 %
4. NEAR 13.3 %
5. POLYGON 16.3 %

The charts shows in most of the time TPM of polygon is much more than others.

The chart shows in May 11,2022 TPM reached to 5k , although the failed transactions increase a little at that time but shows the ability of NEAR chain to handle huge transactions in