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 post
"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
from
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(&tm);
return ( (tm.time*1000) + ((time_t)tm.millitm) );
}
Thanks & Regards
Nitin
"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 exp
looks 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] SQL
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 (Inserts)
> 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 did
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 whi
8 matches
Mail list logo
