In my performance testing IBO and IBX were faster. What exactly are you
doing - just iterating through a query (while not EOF do Next)? Or are you
testing Inserts/Updates as well? If the latter, you will want to
a) Make sure autocommit is off
b) Change the cursor to crHourGlass beforehand for IBX, or use
BeginBusy/EndBusy around the statements for IBO.
Cheers,
Carl
-----Original Message-----
From: Jeremy Coulter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 11 May 2000 10:49 AM
To: Multiple recipients of list delphi
Subject: [DUG]: IBObjects, Interbase controls and BDE
Hi all.
I have been comparing the Native Interbase Controls that come with D5,
IBObjects, and the BDE for performence.
I am not sure here, but I read that IBObjects and the D5 Interbase controls
are meant to be faster than the BDE.
I mad an app, added the above controls then did a test on a 14mb DB.
The query I ran had a left outter join in it to give it a good-ish test,
i.e. not just returning all the files from one tabel, AND the weired thing
is, that the BDE was 2 seconds faster than IBObjects, and 4 seconds faster
than the D5 Native controls !!
This confueses me, as I haev alwasys been lead to believe that the BDE
adding another layer made it slower....has anyone else noticed this ?
Cheers,
Jeremy Coulter
Software Team Leader
Triton Commercial Systems
Christchurch
Ph +64 3 3483973
fax +64 3 3431613
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
