Hacker News new | ask | show | jobs
by leandot 3312 days ago
Good job, curious about the performance when doing multiple AND, OR clauses on 1m+ rows? You'd need compound indices or?
1 comments

Absolutely all the analysis (including filtering) works by generating SQL queries and that SQLite evaluates. Tad doesn't generate any table indices, and I'd be reticent about adding that. However you should be able to Tad as a sqlite viewer from command line (sqlite://foo/bar.sqlite/tablename) and it should make use of indices on your existing SQLite table if you have them.