When Do Transactions Fail?
Q2. Do times of high transaction volume lead to more transaction failures? Create a visualization that shows the relationship between transaction volume and success rate of transactions since May 9th.
Flow is a new blockchain that is simple to use and effective for building the next generation of apps, games, and digital assets.
Flow was also built from the ground up to deliver an exceptional user experience at scale, and it is today a decentralized network sponsored and maintained by a growing community of businesses and Web3 developers.
Read more here
- Retrieve the total number of transaction failures on the Flow chain since May 9th, 2022.
- Compute the daily transaction failure rate on the Flow chain and compare it to the transaction volume.
- Calculate the transaction failure rate by weekday.
- Find the transaction failure rate by time of day.
- Determine whether there is a relationship between the failure rate and transaction volume.
In this section, we will deep dive into the Flow failure transaction rate in three aspects, which is
- (1) Daily transaction since May 9th
- (2) Day of Week
- (3) Hour of Day.
Since May 9th, the charts indicate the failure rate on the Flow chain. We can conclude that 21.6 percent of all transactions were unsuccessful from a total of approximately 11 million transactions.
The graphs show the daily transaction failure count and overall transaction volume since May 9th.
Interestingly, the total transaction volume fluctuates between 300,000 and 700,000 per day, but the daily failure count is quite low prior to May 26th. As a result, we may conclude that transaction failure does not correlate with transaction volume.
One intriguing additional finding is that if we divide the transaction by the hour of the day, the failure rate remains consistent throughout the day. This means that the time of day has nothing to do with transaction failure.
These graphs depict transaction failures by weekday. This data supports the earlier hypothesis that transaction failure is unrelated to transaction volume, particularly on Monday, which has the highest transaction volume but the fewest failure transactions.
-
Since May 9th, 21.6 percent of all transactions from a total of about 11 million transactions had been failed.
-
The total transaction volume varies between 300,000 and 700,000 per day, but previous to May 26th, the daily failure count is fairly low.
-
The data on the day of week supports the preceding theory that transaction failure is unrelated to transaction volume, especially on Monday, which has the highest transaction volume but the fewest failure transactions.
-
One noteworthy additional discovery is that dividing the transaction by the hour of the day results in a consistent failure rate throughout the day.
As a result of this research, we can conclude that transaction failure has no relationship with transaction volume and time of day.