How Many Zero-Transaction Blocks?


When SteemMonster moved away from Steem, I noticed that the number of transactions in a block has been drastically reduced.

That is not good, the number of transactions shows the activity on the steem blockchain, in a way indicates how popular our chain is.

With a little help, I am able to see how many blocks are having zero transactions in the last 24 hours, 7 days, and 2 weeks.

select count(1) from witnessblocks where number=0 and time>=datetime("now", "-1 day");
select count(1) from witnessblocks where number=0 and time>=datetime("now", "-7 day");
select count(1) from witnessblocks where number=0 and time>=datetime("now", "-14 day");
select count(1) from witnessblocks where number>0 and time>=datetime("now", "-1 day");
select count(1) from witnessblocks where number>0 and time>=datetime("now", "-7 day");
select count(1) from witnessblocks where number>0 and time>=datetime("now", "-14 day");

Results

Zero-transactions blocks (24 hours): 263/28257=0.9%
Zero-transactions blocks (7 days): 2000/197666=1.01%
Zero-transactions blocks (14 days): 3425/367386=0.93%

On average, there are 0.9% to 1% per day blocks are containing zero transactions. More investigations can be done once the blocks are fully re-played.


Every little helps! I hope this helps!

Steem On!~ Computing and Technology

If you like my work, please consider voting for me, thanks!
https://steemit.com/~witnesses type in justyy and click VOTE



Alternatively, you could proxy to me if you are too lazy to vote!

Also: you can vote me at the tool I made: https://steemyy.com/witness-voting/?witness=justyy

Visit me at: https://steemyy.com


Comments 2


We are not sure whether not having steemmonsters transactions (mostly bots) is a bad thing for the Steem blockchain itself.

But we agree that it may be viewed as a lack of activity for outside of Steem.

17.07.2020 13:13
0

Agreed, especially the SMS is not entirely on the blockchain - it still holds/process data on centralised servers.

17.07.2020 16:38
0