Re:SQL Indexing and Tuning e-Book
by lsb on Sunday December 16, 2012 @08:58PM
(#4930463)
SQLite 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.
Re:SQL Indexing and Tuning e-Book
by leif on Monday December 17, 2012 @12:48AM
(#4930999)
If 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.
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.