Sqlite performance optimization

Here are some pages that describes some tips for optimizing SQLite usage

http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html [broken]

http://codificar.com.br/blog/sqlite-optimization-faq/

http://wiki.tcl.tk/17365

http://katastrophos.net/andre/blog/2007/01/04/sqlite-performance-tuning-and-optimization-on-embedded-systems/

http://www.sqlite.org/optoverview.html