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

2007-03-30 Thread Dennis Cote
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

2007-03-30 Thread Nitin Kashyap
"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

2007-03-13 Thread Nitin Kashyap
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

2007-03-13 Thread drh
"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

2007-03-13 Thread Doug Nebeker
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

2007-03-13 Thread Nitin Kashyap
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

2007-03-12 Thread Dan Kennedy
> 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