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.