On Tue, Jul 13, 2010 at 12:48 PM, John Drescher <dresche...@gmail.com> wrote: >> I was wondering if that's really so. Wouldn't the marginal speed >> improvement be quite small? Is the percentage of the final rowcount really >> a criterion? > > Each transaction costs at least 1 disk seek. Doing thousands of seeks > the result would be very slow. >
I guess synchronous=off eliminates this flushing / seeking though. John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users