Description of Work:

In these Bounties we want to measure the performance of the Flow network and compare it with the Ethereum, Polygon and Osmosis networks.

The parts we want to do:

• We measure the transactions per minute of Flow since May 9th
• We measure the Successful transactions per minute of Flow since May 9th
• We create a chart that shows how this criterion fluctuated over that time period.
• We check what types of events have raised or decreased the blockchain's performance over that time period?
• Compare Flow's speed with the:
  • Ethereum blockchain network
  • Polygon blockchain network
  • Osmosis blockchain network

1 ---> Transactions per minute of Flow since May 9th

• To do this we use the flow schema and the [flow.core.fact_transactions] table and count the total tx_ids in a minute interval (transactions per minute)

The charts above show the number of transactions per minute from May 9. According to the charts, it can be seen that:

• On May 16, May 29, May 30, 2022 and May 31, we see the highest number of transactions different minutes
• The minimum number of transactions per minute is related to 2022-05-16 22: 57: 00.000 with 12 transactions
• The maximum number of transactions per minute is related to 2022-05-16 03: 36: 00.000 with 3461 transactions
• On May 11, we see the highest number of low transactions in different minutes
• On May 16, from 00:46:00.000 to 05: 28: 00.000, we see the highest number of consecutive transactions per minute.
• In most minutes from May 9 onwards, we see a logical routine in the number of transactions per minute
• On May 16, at 00: 45: 00.000, the number of transactions has multiplied compared to the minute before, and since then, we have seen a significant increase in the number of transactions up to 06: 42: 00.000.

2 ---> Successful transactions per minute since May 9th

• To do this we use the flow schema and the [flow.core.fact_transactions] table and count the total tx_ids in a minute interval (transactions per minute) where [tx_succeeded = 1]

The charts above show the number of succeeded transactions per minute from May 9. According to the charts, it can be seen that:

• On May 28 and 29, we see the lowest number of successful transactions per minute. In most minutes, we see less than 5% of successful transactions compared to all transactions in these two days
• We are witnessing that the process of reducing the number of successful transactions has started on May 26, and we are witnessing this slowdown over time. This slowdown has reached its peak on May 30.
• The lowest percentage of successful transactions with 0.88% corresponds to 2022-05-18 06:17:00.000
• The highest percentage of successful transactions is related to 2022-05-16 04:38:00.000 with 99.82%
• The reason for this decrease in the number of successful transactions at the end of May may be the activation of a new segmented transaction fee structure, which occurred in late May

3 ---> Compare Flow with the Ethereum, Polygon and Osmosis networks on successful transactions per minute since May 9th

• In this section we compare Flow with Ethereum, Polygon and Osmosis in terms of number of total and successful transactions per minute. For do this:
  • We use the [ethereum.core.fact_transactions] table for count Ethereum total and successful transactions per minute
  • We use the [polygon.transactions] table for count Polygon total and successful transactions per minute
  • We use the [osmosis.core.fact_transactions] table for count Ethereum total and successful transactions per minute

According to the results obtained by comparing the number of total and successful transactions per minute, it is clear that:

• The number of total and successful transactions per minute in Polygon is much higher than the others. After Polygon, Ethereum has the highest number of successful transactions per minute, followed by Flow and Osmosis.
• The number of total and successful transactions at Polygon has dropped dramatically since Jun 1
• Interestingly, the number of total and successful transactions in Ethereum is almost constant and there is no noticeable sudden change. This shows the stability of this network
• According to these descriptions, performance and Flow speed are in the third place among Ethereum, Polygon and Osmosis. (Above Osmosis and Below Ethereum and Polygon)

4 ---> Check what types of events have raised or decreased the blockchain's performance over that time period?

• In this section, we examine the effect of event type on Flow. To do this, we use the [flow.core.fact_events] table and the [event_type] field to count and analyze all successful transactions over a period of one minute for each event_type.

According to the results obtained by effect of event type on Flow performance, it is clear that:

• Types of events related to token operations such as TokensWithdrawn, TokensDeposited or operations on wallets such as Deposit and Withdraw and fee related operations such as FeesDeducted have the greatest impact on Flow speed.
• The number of successful transactions per minute for TokensWithdrawn and TokensDeposited is almost equal and have the greatest impact on the Flow speed.
• After TokensWithdrawn and TokensDeposited, the FeesDeducted event type has the greatest impact on Flow speed. And then Withdraw and Deposit

5 ---> Transaction volume or interest on the chain

• In this section, we review the number of successful transactions and the volume of successful transactions from May 9 until now on a daily basis for the **TokensDeposited event type.

The charts above show the number of successful transactions for TokensDeposited on a daily basis from May 9 onwards

• According to the results can be seen that:
  • The number of daily transactions decreased in late May
  • The reason for this decrease in the number of successful transactions at the end of May may be the activation of a new segmented transaction fee structure, which occurred in late May
  • The number of transactions has increased since May 31
  • The maximum number of daily transactions is related to May 9 and Jun 3
  • The daily transaction volume for TokensDeposited is seen as a steady trend except May 26th
  • On May 26, the transaction volume increased significantly and then stabilized again