I would guess PRAGMA synchronous. Per documentation: "In SQLite version 2, the default value is NORMAL. For version 3, the default was changed to FULL."
Try setting it to NORMAL for v3 tests and see what that does. -- Mike On Thu, Mar 27, 2008 at 11:06 PM, Richard Klein <[EMAIL PROTECTED]> wrote: > I've recently upgraded from SQLite 2.8.17 > to 3.5.6. > > Upon running a test program that measures > the execution time of SQL statements typical > for my application, I've noticed a definite > performance degradation: > > INSERT: 34% slowdown > UPDATE: 47% " > DELETE: 50% " > > Has anyone else noticed this? I haven't done > any profiling of the code (yet) to see where > the time is being spent. > > - Richard > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
