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

Caching results #316

Open
PaulPoulain opened this issue Feb 15, 2022 · 0 comments
Open

Caching results #316

PaulPoulain opened this issue Feb 15, 2022 · 0 comments
Labels
enhancement New feature or request

Comments

@PaulPoulain
Copy link
Member

When you run a report or a dashboard, Urungi calculate every SQL query every time. Sometimes it's not needed because the results are valid for minutes (or hours or days)
Proposal : when you create a report, have an option saying "results are valid for ___ minutes". If ___ > 0, then store the results in a JSON. If the report is re-run, check if the cache validity, and, if still valid, use the JSON in cache instead of running the SQL again.
PS : below the field (or as a hint), remind that 1 day = 1440mn

@PaulPoulain PaulPoulain added the enhancement New feature or request label Feb 15, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant