Well.....as it turned out, IBO was only 25 seconds slower than ISQL.
We have a DB that has 743,000 records in it....ISQL took 6:15 to run, IBO
took 6:42, and teh BDE took......8:49 !!
Ok...thats a big DB, but thats ok, good performence testing.
the prob. is also, too many records are being returned too...but that was
out of my hands, as I was not here then...
Jeremy Coulter
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Carl Reynolds
> Sent: Thursday, 11 May 2000 16:58
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: IBObjects, Interbase controls and BDE
>
>
> 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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
