Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

KPI tracker metrics unusable with high transaction count #139

Open
abizjak opened this issue Apr 7, 2024 · 0 comments
Open

KPI tracker metrics unusable with high transaction count #139

abizjak opened this issue Apr 7, 2024 · 0 comments
Labels
[Type] Bug Something isn't working

Comments

@abizjak
Copy link
Contributor

abizjak commented Apr 7, 2024

Bug Description

The KPI tracker metrics for activity and transaction counts are not usable with high transaction load.

The reason for htis is that we don't compute the metrics on the fly, and thus to display them we have to go through all transactions in a certain period and reconstruct the counts.

We need to change this so that the relevant metrics are computed on the fly and stored, either via materialized views or a separate table.

We can sacrifice some accuracy, e.g., we can just have buckets of 1 day for transaction counts.

@abizjak abizjak added the [Type] Bug Something isn't working label Apr 7, 2024
@mh-concordium mh-concordium added the [Res] works as designed The functionality is as intended. label May 13, 2024 — with Linear
@mh-concordium mh-concordium removed the [Res] works as designed The functionality is as intended. label May 13, 2024
@limemloh limemloh removed their assignment Sep 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
[Type] Bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants