This PR removes the block_latency calculation logic from both the Kotlin code and the PostgreSQL stored procedure. The reason for this removal is that calculating latencies for large ranges of blocks would cause the process to run for hours without completing, which halted block collection.
Key Changes:
Removed block_latency calculation: The stored procedure update_block_latency() and all references to block_latency in the Kotlin code have been removed.
Code cleanup: Simplified queries and removed unnecessary logic that dealt with block_latency.
By removing this, we avoid performance issues that were affecting block collection, especially when handling large datasets.
closes: #XXXX
Before we can merge this PR, please make sure that all the following items have been
checked off. If any of the checklist items are not applicable, please leave them but
write a little note why.
[ ] Targeted PR against correct branch (see CONTRIBUTING.md)
[ ] Linked to Github issue with discussion and accepted design OR link to spec that describes this work.
[ ] Wrote unit and integration
[ ] Added a relevant changelog entry to the Unreleased section in CHANGELOG.md
[ ] Re-reviewed Files changed in the Github PR explorer
[ ] Review Codecov Report in the comment section below once CI passes
Description
This PR removes the
block_latencycalculation logic from both the Kotlin code and the PostgreSQL stored procedure. The reason for this removal is that calculating latencies for large ranges of blocks would cause the process to run for hours without completing, which halted block collection.Key Changes:
block_latencycalculation: The stored procedureupdate_block_latency()and all references toblock_latencyin the Kotlin code have been removed.block_latency.By removing this, we avoid performance issues that were affecting block collection, especially when handling large datasets.
closes: #XXXX
Before we can merge this PR, please make sure that all the following items have been checked off. If any of the checklist items are not applicable, please leave them but write a little note why.
Unreleasedsection inCHANGELOG.mdFiles changedin the Github PR explorerCodecov Reportin the comment section below once CI passes