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

[Task]: Debug intermittent excess load placed on SQlite DB by excess queries #300

Closed
alex-mcgovern opened this issue Feb 11, 2025 · 1 comment

Comments

@alex-mcgovern
Copy link
Collaborator

Description

While working with @danbarr he noticed some DB locks while using the dashboard normally.
It looked like there are probably a few things going on here:

  • excess reads from the frontend — there may be opportunities to more heavily leverage cache
  • long reads due to no pagination on the server — Dan's got a lot of messages & alerts locally

Additional Context

No response

@alex-mcgovern
Copy link
Collaborator Author

I investigated this, using @tanstack/react-query-devtools — there doesn't seem to be a very excessive number of queries being triggered from the frontend (like we saw in the past).

It seems this issue is related to the number of records present on his machine, which will be adressed in the future by pagination.

I've tracked this separately here: stacklok/codegate#1020

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant