Try Quests to earn FLOWFLOW Speed (redux)
Flow Introdution
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.
Method
Using the flow.core.fact_transactions, ethereum.core.fact_transactions, and osmosis.core.fact_transactions table, we will compare number of transactions, number of users, success rate, and number of failed transactions of Flow, Osmosis, and Ethereum chains.
And in the first stage, we will examine how flow transactions have grown compared to other chains
In next step, we will categorize transactions based on type of transactions and check each code separately.
Questions
Flow is fast, but how fast?
6 months ago, we asked for a comparative analysis on blockchain speed - how has Flow increased its speed in transaction per minute since? Compare Flow and other L1 blockchains in terms of speed: identify the monthly average for transactions per minute, and how that's improved or worsened since the beginning of 2022.
- What types of events have raised or decreased the blockchain's performance over that time period?
- Are there bursts of transaction volume or interest on the chain? Compare Flow's speed to at least two other blockchains.
total number of transactions on Flow network from first day of 2022 until today is 214.8M transactions made by 17.8M unique users.
total number of Ethereum users is 92.8M users who have made a total of 376.6M transactions on Ethereum, Ethereum has largest number of transactions and users, with a ratio of 80% in transactions and 57% in number of users.
number of Flow users increased in October, reaching 3 million weekly users on November 21
total number of transactions on the Osmosis network is 62.3M transactions made by 4.4M users
weekly number of transactions on Osmosis suddenly halved in June
number of transactions per user on Flow chain is increasing every week, and Flow users are becoming more active week by week and each one does more transactions on flow chain
most types of transactions recorded on Flow have been for depositing and withdrawing tokens, and label of this event has been identified on Flow blockchain with the names TokensWithdrawn and TokensDeposited.
Since the beginning of May, number of transactions of this type has been gradually increasing
But in last few weeks, weekly number of these transactions has dropped a little
total number of TokensDeposited transactions is almost 167K transactions, which is same as number of TokensWithdrawn transactions
number of FeesDeducted transactions is 786
Transactions related to token deposit and withdrawal and FeesDeducted account for about 20% of transactions each, which is largest share of all transactions.
Since October 17, success rate of Flow transactions has started to decrease, but in recent weeks, success rate has increased again.
failed rate of Osmosis transactions has also increased significantly since July 11th and decreased again on August 8th.
weekly number of successful transactions on Flow blockchain has exceeded that of Ethereum in some days
most successful weekly transactions on Flow were on June 20, when 10.5M successful transactions were recorded on Flow in one week.
As you can see, number of monthly blocks of Flow is much more than other chains
and monthly number of flow blocks is between 1.7M and 2M blocks
Since June, the number of transactions has increased every week and with a gentle slope
Conclusions and findings
total number of transactions on Flow network from first day of 2022 until today is 214.8M transactions made by 17.8M unique users.
total number of Ethereum users is 92.8M users who have made a total of 376.6M transactions on Ethereum, Ethereum has largest number of transactions and users, with a ratio of 80% in transactions and 57% in number of users.
number of Flow users increased in October, reaching 3 million weekly users on November 21
total number of transactions on the Osmosis network is 62.3M transactions made by 4.4M users
weekly number of transactions on Osmosis suddenly halved in June
number of transactions per user on Flow chain is increasing every week, and Flow users are becoming more active week by week and each one does more transactions on flow chain
Since October 17, success rate of Flow transactions has started to decrease, but in recent weeks, success rate has increased again.
failed rate of Osmosis transactions has also increased significantly since July 11th and decreased again on August 8th.
weekly number of successful transactions on Flow blockchain has exceeded that of Ethereum in some days
most successful weekly transactions on Flow were on June 20, when 10.5M successful transactions were recorded on Flow in one week.
As you can see, number of monthly blocks of Flow is much more than other chains
and monthly number of flow blocks is between 1.7M and 2M blocks
Since June, the number of transactions has increased every week and with a gentle slope
most types of transactions recorded on Flow have been for depositing and withdrawing tokens, and label of this event has been identified on Flow blockchain with the names TokensWithdrawn and TokensDeposited.
Since the beginning of May, number of transactions of this type has been gradually increasing
But in last few weeks, weekly number of these transactions has dropped a little
total number of TokensDeposited transactions is almost 167K transactions, which is same as number of TokensWithdrawn transactions
number of FeesDeducted transactions is 786
Transactions related to token deposit and withdrawal and FeesDeducted account for about 20% of transactions each, which is largest share of all transactions.