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

Reduce query runs before cache hit from 3 to 2 #35630

Closed
likeshumidity opened this issue Nov 10, 2023 · 0 comments · Fixed by #38400
Closed

Reduce query runs before cache hit from 3 to 2 #35630

likeshumidity opened this issue Nov 10, 2023 · 0 comments · Fixed by #38400

Comments

@likeshumidity
Copy link
Contributor

Is your feature request related to a problem? Please describe.
PLEASE VERIFY BELOW AND EDIT IF INCORRECT
Currently AFAIK, saved question caching works like below:

  • 1st query run (i.e. first time query is every run) - generates an entry in the query_execution and query tables
  • 2nd query run - sees query execution time and determines if it should cache results
  • 3rd query run - uses cached question if cached in prior run and not expired

Describe the solution you'd like

  • determine if results should be cached and cache them in every non-cached query run to reduce # of query runs from 3 to 2

Describe alternatives you've considered

  • no change, reduces cache usage

How important is this feature to you?

  • helpful to make better usage of cache
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants