News for hackers. Stuff that matters.
Re:SQL Indexing and Tuning e-Book by quux on Sunday December 16, 2012 @06:04PM (#4929951)
Looks very interesting, can anyone say if this material also applies to SQLite?
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.