I am trying to optimize the speed of my SQLite transactions. The goal is to beat query and insertion times that we have with MS SQL. I guess there are 2 main issues:
1) The query times are faster when I do simple select statements on a large amount of data. I start to run into trouble when I get into more complex join statement that involve date conversion functions. I've read that replacing joins with "WHERE" statements that involve consideration of the ordering of tables in FROM statement can help with speed. However, I am a little skeptical since I think that this consideration was already made in the current implementation. 2) I've tried ramping up the "cache_size" (from 2000 to 10000), but I don't see any effect, even with simple select statements. Does this seem strange? I've consulted the following site: http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html#pragma-cache_size SQLite Optimization for advice on how to optimize SQLite. Does anyone know of any other resources on the topic of optimizing SQLite? Any advice welcome, thanks. -- View this message in context: http://old.nabble.com/SQLite-Optimization-tp26630742p26630742.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
