we should consider that only Flow and Ethereum has about full support and other blockchain has limited support.

with current status of data Polygon has best Average time and Flow,follow Polygon.worst gap between TX is for Ethereum. and this was predictable for many reason. some of them are :

1. older blockchain and some user may doing TX afters years while other blockchain may have less than 2,3 years old.
2. higher gas fee. this effect from two side. one is harder for normal user do transaction besuae cost lot’s of money. two remove bots from blockchain from doing fake TX

from number of unique Address ethereum by far has largets amount of address (user) .second place goes to Flow and Polygon take thrid sit.

What is Flow? Flow is a fast, decentralized, and developer-friendly blockchain, designed as the foundation for a new generation of games, apps, and the digital assets that power them. It is based on a unique, multi-role architecture, and designed to scale without sharding, allowing for massive improvements in speed and throughput while preserving a developer-friendly, ACID-compliant environment.

what is EVM blockchain? all blockchains that use Ethereum Virtual machine are EVM blockchain. with using EVM blockchain can power from all smart contract that written for Ethereum with small change and tweaks

> image created by me with figma and jokerman font

Distribution of Average Time between two Transaction in Flow vs EVMs

Goals

in this article i want to compare flow blockchain with other EVM compatible blockchain to calculate how long take between two transaction from one user. main question that i want to answer is :

1. How does Flow compare to other L1s in terms of user retention?
2. Is a user who made a transaction previously likely to make another transaction a week or a month later?
3. How is this statics Compare and contrast this type of activity vs other L1s like Solana and Ethereum?

if like other article i start to step by step solve question maybe boring for readers so i decide to change this method. with help of powerful Parameters from Flipsidecrypto. I decide to separate this comparison in two part. 1. compare this info with static and numbers. 2. compare chart of this information.

now it is time to see results but let’s first see some information for better work with this data

Prerequisite

in this article we have three parameter. these are :

1. blockchain : the blockchain that we want to compare Flow with this. these blockchain are : 1. Ethereum 2. Avalance 3. BSC 4. Polygon and Ethereum L2 : 1. Optimism 2. Arbitrum.
2. timeframe : contains 1. Week 2. Month these are parameters used in query in chart to show timeframe gap between two transaction
3. all_timeframe : contains 1. second 2. minute 3. hour 4. day. this parameter used in calculation average time gap between two transaction in big number cards

there is some notice in query that maybe help to better understanding these are :

• with LAG function we can previous TX time so I created I view that hold TX time , previous TX time , sender of TX and different time between two TX.
• next I remove rows that previous and current TX have same time. this work remove time of first TX. because in first TX we don’t have previous TX so LAG function put time of this TX as default and this only happens in first TX.

warning : at current time database of Polygon,BSC,Avalanche,Arbitrum,Optimism is in lite mode and has limited data and result should not consider as reliable source.in this article I just brief look at this data and completed after full support all of this Blockchains

Conclusion

this part maybe different from other conclusion. I think reviewing time between TX A and B without seeing whole blockchain maybe have wrong result. I think this gap come from combination of Blockchain Dapps and TX Fee and Number of User .for example blockchains Flow and **Polygon (**although time duration in different) but with same user and cheap gas fee and same amount of user have same result.

anther points is about Ethereum blockchain. with more than ==90M== users that average TX gap time is more less than one week has done incredible job.

Average Time Between Two TX in Flow vs EVMs

in last part i calculate average time between two TX from user of each blockchain but in this part i want to calculate this for each in All blockchains and show distribution of this gap in timeframe month and week.

by setting parameter we can easily compare this distribution but there some notice that i want to see in this part:

• Ethereum : for more than 90M address, average time gap between each transaction is less than 1 week
• Flow : more than 85% of address doing TX with gap less than 1 week and only 12 address has TX with gap between 6,7 week
• Avalanche , Arbitrum , BSC : data for these blockchain has less than month age and for them more than 80% of user in this period repeat TX with gap less than 1 week
• Polygon, Optimism : data for these blockchain has less than two month week and for all of than more than 90% of user in this period repeat TX with gap less than 1 week

Introduction