-
Notifications
You must be signed in to change notification settings - Fork 317
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
Large results are slow #153
Comments
Yeah this would be a nice enhancement. We'd need to wrap the user query to add a LIMIT / OFFSET to support pagination, not sure if there are any ramifications there. Performance will largely depend on what indexes are available. |
Pagination and stuff is a little tricky since we have to use a POST (because some janky ass home automation software doesn't understand url-encoded newlines), but I think both the a) performance issue, and b) pagination should be resolved now. Please give it a try when you're able. |
If the query result is large, I have to wait for the whole query to finish before I see anything.
In contrast,
sqlite
CLI streams such results to stdout. It is helpful because:I would expect sqlite-web to do one of:
The text was updated successfully, but these errors were encountered: