[sqlite] SQLite v/s SQLite3 Performance Assay

Hi All, I Carried out a small assay comparing performance between SQLite-2.8.16 & SQLite-3.3.9; Over Multiple platforms & Operating Environments. Please consider the observations of the assay below. There seems to be a very clear and visible difference in performance of SQLite & SQLite3; for

Re: [sqlite] SQLite v/s SQLite3 Performance Assay

Version 3 has a different default safety-level (default FULL) to version 3 (default NORMAL). So if you didn't explicitly set the safety-level during the tests, then version 3 was syncing the disk more often than version 2. I think this might be why version 3 appears slower in Test Case I

Re: [sqlite] SQLite v/s SQLite3 Performance Assay

Hi Doug, My bad... the getTickCount() in the snippet is basically a wrapper over ftime call, and the same is used on the linux platform also for timing. time_t getTickCount() { timeb tm = {0}; ftime(); return ( (tm.time*1000) + ((time_t)tm.millitm) ); } Thanks & Regards Nitin K

Re: [sqlite] SQLite v/s SQLite3 Performance Assay

"Nitin Kashyap" <[EMAIL PROTECTED]> wrote: > > My Intentions are towards exploring the reason behind these differences; > and what can be done to counter these performance differences. I'm > seeking some pointers from the Community. > I'm guessing that the p