4 ms·
Looks very interesting, can anyone say if this material also applies to SQLite?
by quux 14y ago
Looks very interesting, can anyone say if this material also applies to SQLite?
- lsb 14y agoSQLite only makes B-Tree indices, not hash or bitmap, and there are no clustered indices, for instance. But there are indices spanning multiple columns, there are ephemeral indices (when doing an n^2 query would be prohibitive), there are self-analytics (to gauge the efficacy of using an index in a query). It's an entire book, so it's tough to say in a small comment box. If you're doing queries across a 5MB database on a phone, you should be fine with or without optimizations.
- leif 14y agoIf you're doing queries across a 5MB database frequently on a phone, you should think carefully about your indexes because you're responsible for battery life.