Skip to content

Support creating descending order indexes #260

@simonw

Description

@simonw

SQLite lets you create indexes in reverse order, which can have a surprisingly big impact on performance, see simonw/covid-19-datasette#27

I tried doing this using sqlite-utils like so, but it's didn't work:

db["ny_times_us_counties"].create_index(["date desc"])

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions