Get the latest tech news
Subtleties of SQLite Indexes
Understanding query planner quirks yielded a ~35% speedup.
It includes an ID, URL, title, language, publish date (stored as a Unix timestamp), and a text quality rating. Scour's main ranking query filters items based on when they were published, whether they are in a language the user understands, and whether they are above a certain quality threshold. If a query has multiple range conditions, it may be worth putting the columns that use strict equality first in the index, like we did above with lang coming before published or low_quality_probability.
Or read this on Hacker News