Re: [sqlite] Performance degradation when using sqlite 3.3.5 program against sqlite 3.2.1 db-files

The database version does not impact performance much. You can verify this yourself by converting your database files to the 3.3.5 format. I'm guessing that you are seeing a difference in query performance between 3.2.1 and 3.3.5. Much code has changed between these two versions, including the a

[sqlite] Performance degradation when using sqlite 3.3.5 program against sqlite 3.2.1 db-files

We have recompiled several applications with new sqlite 3.3.5 library. We have observed that one of these application, which access intensively (read-only) a large number (around 180) of old sqlite 3.2.1 db-files (4 million records, 2GB, each) runs now much slower. These files are updated sporadic