Dear D. Richard Hipp,
I had some strange result on some PCs,
a) On my notebook (P3 899, 256Mbytes, WinXP) when do insert a
records to a blank table, it > 100% slower as compare to other.
(< 3000 rows).
b) On one of PC (Celeron 1.7G, 256MBytes WinXP), when do search.
it will 100% slower as compare to others, (> 8000 rows)
Infact it slower then a Celeron 633 with 128M Win98.
for indx := 0 to QstLst.Count - 1 do
begin
qryQst.SQL = 'Select * from QstTbl As Q, LstTbl As L where L.QstID=''' +
QstLst.Strings[indx] + ''' AND Q.QstID=L.QstID';
qryQst.Open( );
...
...
end;
Do u have any complete compiled application to check the perfomance.
Regards
KL Chin
-----Original Message-----
From: D. Richard Hipp [SMTP:[EMAIL PROTECTED]
Sent: Wednesday, April 14, 2004 7:15 PM
Cc: [EMAIL PROTECTED]
Subject: Re: [sqlite] MySQL / SQLite
Hannes Roth wrote:
> 2. Why is SQLite twice as fast when using a small database (<3000 rows)
> and twice as slow when using a large database (>8000 rows)?
>
The speed comparison at http://www.sqlite.org/speed.html uses tables
with 25000 rows and is twice as fast as MySQL. I don't know why yours
is slower - you did not give much data to go on. Perhaps if you
supplied some information about your database (the schema, what
indices are defined, what data is being stored, what your queries
look like) someone could better answer your question.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
