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

Nitin Kashyap wrote: I have tried to verify for any test artifact as suggested by you; but still the result were same. Requesting for further guidance as to what can cause the slow responnce from SQLite3 compared to SQLite2. Also, I had sent the snippet from the test driver in previous

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 poor performance you are getting

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 use SQLite for a lot of different things (as you would

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

slower than v2? I wouldn't think so--you'd think it would skew the results equally for both tests. Doug -Original Message- From: Nitin Kashyap [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 13, 2007 2:51 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQLite v/s SQLite3

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

> 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. Version 3 has a different default safety-level (default FULL) to version 3 (default NORMAL). So if you

[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