search

provenance-io / explorer-service

The server side of the blockchain Explorer app. Allows for UI browsing of the blockchain.
Apache License 2.0
6 stars 3 forks source link

Determine if the limit query optimizes performance in `calculateMissedAndInsert` #546

Closed nullpointer0x00 closed 1 month ago

nullpointer0x00 commented 1 month ago

Summary

Determine if the limit query optimizes performance in calculateMissedAndInsert by tracking execution times. If successful, remove the warning.

Problem Definition

The warning was added to monitor if applying a limit to database queries resolves inefficiencies in calculateMissedAndInsert. The method had been taking over 1000ms to execute due to fetching and serializing large data sets, causing performance issues.

Proposal

Monitor the performance improvements and remove the warning if the issue is resolved.
PR: #544

nullpointer0x00 commented 1 month ago

We removed all this code completely with https://github.com/provenance-io/explorer-service/pull/548.