This PR removes the logic for calculating running_count and total_count in the missed_blocks table. We no longer need to store these values in the database since they can be easily derived with a simple query when necessary.
Previously, the calculation of these values could take several minutes when a validator missed a block, especially with large datasets. Now, only the consensus_address and block_missed are stored, which eliminates that overhead. The counts were not used in any endpoints or elsewhere in the code, so this cleanup improves performance without affecting functionality.
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 logic for calculating running_count and total_count in the missed_blocks table. We no longer need to store these values in the database since they can be easily derived with a simple query when necessary.
Previously, the calculation of these values could take several minutes when a validator missed a block, especially with large datasets. Now, only the consensus_address and block_missed are stored, which eliminates that overhead. The counts were not used in any endpoints or elsewhere in the code, so this cleanup improves performance without affecting functionality.
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.
Unreleased
section inCHANGELOG.md
Files changed
in the Github PR explorerCodecov Report
in the comment section below once CI passes