Re: [sqlite] 2.8.17 --> 3.5.6 performance regression

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

Re: [sqlite] 2.8.17 --> 3.5.6 performance regression

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]>

[sqlite] 2.8.17 --> 3.5.6 performance regression

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