4 ms·
Good job, curious about the performance when doing multiple AND, OR clauses on 1m+ rows? You'd need compound indices or?
by leandot 9y ago
Good job, curious about the performance when doing multiple AND, OR clauses on 1m+ rows? You'd need compound indices or?
- antonycourtney 9y agoAbsolutely 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.