Mike, You guessed correctly! I inserted a "PRAGMA synchronous = NORMAL;" into the SQLite 3 version of my test suite, and obtained the same performance as I observed with SQLite 2.
I should have realized that the kind of slowdown I was observing could only be explained by extra disk I/O operations. Thanks for your help! - Richard > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
