Polygon Block Performance
Questions :
> ### What is the average time between blocks on Polygon? > > ### What was the maximum and minimum recorded time between two blocks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
Introductions :
> ### A block is a place in a blockchain where information is stored and encrypted. Blocks are identified by long numbers that include encrypted transaction information from previous blocks and new transaction information. Blocks and the information within them must be verified by a network before new blocks can be created. > > ### Block time is the measure of the time it takes the miners or validators within a network to verify transactions within one block and produce a new block in that blockchain.
Metods :
> ### First i create a CTE and selected all blocks and their time from block table and ranked them by their block number and after that i created another CTE and again selected all blocks and their time except first block and then ranked them by block number and then i used this two CTE and calculate time between blocks with this code CAST(DATEDIFF(SECOND, TIME1, TIME2)
> ### my discord : msafadoost #5494 > > ### Creation date : 2022-07-25