On Jun 3, 2011 10:31 AM, "Ian Hardingham" <i...@omroth.com> wrote: > > Hey guys, once again thanks for the help. > > Should really every single INSERT/UPDATE section have a begin/end > transaction around it?
There's an implied begin/commit if you don't put them there. It's when you can batch lots of INSERT/UPDATE/DELETEs that it really pays to use one large transaction for them (also, for atomicity and isolation). Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users