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

Performance problem: GetFrom and GetFromTo queries do not use an index #38

Open
drauch opened this issue Jun 5, 2023 · 0 comments
Open

Comments

@drauch
Copy link

drauch commented Jun 5, 2023

The fix implemented in #35 ruined the performance of the GetFrom and GetFromTo queries. It's still required to use CommitStamp, CheckpointNumber as ORDER BY clause in order that the corresponding index can be used.

Unfortunately I don't have the time for a pull request, but it should be a fairly minor change anyways, most effort will be to test that the index is now indeed used by the query.

Best regards,
D.R.

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