I will when I get the chance, but I am trying to get a list of things to try to improve my SELECT speeds. If it is one SELECT, but returning +-10000 rows, it probably won't make a difference, right?
On Tue, Nov 22, 2011 at 11:41 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 11/22/2011 04:34 PM, Baruch Burstein wrote: > >> Do transactions speed up SELECT statements? >> >> > They can a bit. If you put 10 SELECT statements in a transaction > SQLite only has to lock and unlock the database file once. If > you run them outside of a transaction the db is locked and unlocked > 10 times. > > Best to experiment to find out if this is significant for your > app. > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > -- Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rich Cook _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
