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

Pagination: Optimize SQLite query #2

Open
lvm opened this issue Jul 7, 2016 · 0 comments
Open

Pagination: Optimize SQLite query #2

lvm opened this issue Jul 7, 2016 · 0 comments
Assignees
@lvm
Labels
enhancement

Comments

@lvm
Copy link
Owner

lvm commented Jul 7, 2016

Right now the query uses OFFSET and LIMIT which works OK but would be better to use INDEX as it would be more efficient.
@lvm lvm added the enhancement label Jul 7, 2016
@lvm lvm self-assigned this Jul 7, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@lvm lvm

Labels
enhancement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@lvm