We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
Sorting that by date makes sense for seeing most recent points, and my DB has 2.5m points in so it's an expensive sort!
The text was updated successfully, but these errors were encountered:
Workaround:
sqlite-utils create-index healthkit.db workout_points -- -date
See https://sqlite-utils.datasette.io/en/stable/cli.html#creating-indexes
Sorry, something went wrong.
Also on workout_points.workout_id to speed up queries to show all points in a specific workout.
workout_points.workout_id
No branches or pull requests
Sorting that by date makes sense for seeing most recent points, and my DB has 2.5m points in so it's an expensive sort!
The text was updated successfully, but these errors were encountered: