[yunqa.de] Performance differences between SQLiteSpy and DISQLite3
- From: Markus Weisser <weisser@xxxxxxxxxxxxxxxxxxxx>
- To: "yunqa@xxxxxxxxxxxxx" <yunqa@xxxxxxxxxxxxx>
- Date: Fri, 5 Apr 2013 10:39:12 +0000
Hi,
I have a query that runs pretty fast in SQLiteSpy (1.9.1). Joining 4 tables and
get some avg, min and max values with a group by clause took about 360ms to get
200 result values.
However, running the same query in an application with DISQLite3 4.2.0 took
more than 12 seconds!
..
l_Query := ResultDb.Prepare16(SQL);
while l_Query.Step = SQLITE_ROW do
begin
... //writing data to a grid, but this is not critical in performance
end;
each call of Step took about 60ms.
Is there a faster way to fetch the data that is used in SQLiteSpy?
Thanks in advance,
Markus
Diese E-Mail kann vertrauliche und/oder rechtlich geschützte Informationen
enthalten. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und
vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte
Weitergabe dieser E-Mail ist nicht gestattet. Rechtlich verbindliche
Erklärungen dürfen über dieses Medium nicht ausgetauscht werden. Diese erfolgen
ausschließlich in Papierform über den Postweg.
This e-mail may contain confidential and/or privileged information. If you are
not the intended recipient (or have received this e-mail in error) please
notify the sender immediately and destroy this e-mail. Any unauthorized
copying, disclosure or distribution of the material in this e-mail is strictly
forbidden. No legally binding commitments will be created by this e-mail
message. Where we intend to create legally binding commitments these will be
made through hard copy correspondence or documents.
Other related posts:
