There is an unfinished {link: http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html SQLite Optimization FAQ} which concentrates on optimizing for speed when using the sqlite library in a C application.