Re:Tad, a tabular data viewer
by leandot on Wednesday May 31, 2017 @11:22AM
(#14453202)
Good job, curious about the performance when doing multiple AND, OR clauses on 1m+ rows? You'd need compound indices or?
[ Parent
| on HN ]
Re:Tad, a tabular data viewer
by antonycourtney on Thursday June 01, 2017 @10:23AM
(#14460457)
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.