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.

Sign up for GitHub

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

Jump to bottom

Auditor: Performance improvements for querying records #736

Closed
QuantumDancer opened this issue Mar 25, 2024 · 0 comments · Fixed by #817
Closed

Auditor: Performance improvements for querying records #736

QuantumDancer opened this issue Mar 25, 2024 · 0 comments · Fixed by #817
Assignees
@raghuvar-vijay
Milestone
Release v0.6.0

Comments

@QuantumDancer
Copy link
Collaborator

We noticed that the performance of querying records degrades when a lot of records (e.g. 100k or 1M) are stored in the DB. Even when we only query one record, this can take up to 40s. We should look into optimizing our SQL queries and try to reduce the query time.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@raghuvar-vijay raghuvar-vijay

Labels
None yet
Projects
None yet
Milestone
Release v0.6.0
Development

Successfully merging a pull request may close this issue.

feat: Migrate to jsonb column type for meta and component fields raghuvar-vijay/AUDITOR
2 participants
@QuantumDancer @raghuvar-vijay