IBX did take a wee bit longer.....but unfortunitly IBX dosent factor into
int anymore, as we need the Filter property on the query object
Jeremy Coulter
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Carl Reynolds
> Sent: Thursday, 11 May 2000 17:13
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: IBObjects, Interbase controls and BDE
>
>
> Out of interest, did you try it using IBX? How long did that take?
>
> Cheers,
> Carl
>
> -----Original Message-----
> From: Jeremy Coulter [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 11 May 2000 3:06 PM
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: IBObjects, Interbase controls and BDE
>
>
> 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
> ------------------------------------------------------------------
> ---------
> 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
