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

Search by source should be faster #45

Open
waldiTM opened this issue Dec 14, 2023 · 0 comments
Open

Search by source should be faster #45

waldiTM opened this issue Dec 14, 2023 · 0 comments
Labels
kind/enhancement Enhancement, improvement, extension

Comments

@waldiTM
Copy link
Contributor

waldiTM commented Dec 14, 2023

What would you like to be added:
The search by source needs to be revamped to use maybe a temporary table. Such a table can be filed pretty efficient with the PostgreSQL specific COPY IN.

Why is this needed:
This search is pretty slow. Most of the time is lost in rendering a query with several thousand variables. The execution time is almost neglectible.

@waldiTM waldiTM added the kind/enhancement Enhancement, improvement, extension label Dec 14, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
kind/enhancement Enhancement, improvement, extension
Projects
None yet
Development

No branches or pull requests

1 participant