vocdoni / vocdoni-node / 10770887514

62%

main: 63%

Build Type

Pull #1383

github

Committed by altergui

Commit Message

indexer: optimize idx.BlockList performance

turns out, a unified query with `COUNT(*) OVER() AS total_count` is 10x slower
than two separate queries `SELECT *` and `SELECT COUNT(*)`

also, optimize even further (~1000x) for the most common query:
when listing all blocks without filters, don't even count, just return last height

the benchmark code used to test is included

Pull Request Pull Request #1383: feat/indexer hotfixes

Run Details

16 of 45 new or added lines in 4 files covered. (35.56%)

20 existing lines in 3 files now uncovered.

16803 of 26967 relevant lines covered (62.31%)

38006.21 hits per line