Subject RE: [IBO] for Jason: TIBOQuery vs. TFIBDataset speed test
Author Jason Wharton
That sounds much longer than necessary.

If you would, please send me a DDL script of your database and an example
app that represents this problem where I can click a button and see what is
going on.

More than likely there are other things being done up front with IBO that
may not need to be done and I can show you how to defer them and there may
be other things that could cause other internal statements to be prepared
that with FIB there are no other internal cursors to prepare. However, it
is these internal cursors within IBO that give special capabilities that can
shave off lots of time while users are interacting with the application.

Also know it is true IBO is a little slower when preparing a bunch of
datasets than the other products like FIB because they are so trim and
simple. THere are things IBO has optimized performance for and preparing
datasets is one spot where I have put some of the burdens to make other
things faster.


> -----Original Message-----
> From: Enrico Raviglione [mailto:e.raviglione@...]
> Sent: Tuesday, March 15, 2005 11:27 AM
> To:
> Subject: [IBO] for Jason: TIBOQuery vs. TFIBDataset speed test
> Hi Jason,
> i use IBObejct from about 3 years but there are a problem that now i
> must solve.
> At 95% i use only TIBOQuery, TIB_Cursor and TIB_StoredProc.
> The problem are: in some case i must open a large number of query
> because i have some complex Form with a lot of
> lookup-combo-box and for
> any of this combo-box i have a different database table/view/sp.
> With TIBOQuery components opening a large number of tables (or a large
> table) are alwais "a long job" for my applications.
> Then i have tested FIB Plus component and with my surprise i have
> discover that there are a very big difference in time needed
> for opening
> a TIBOQuery or opening a TFIBDataset.
> In my little test, when i only open a lot of query on a database, the
> result are:
> IBO open all queries in 1 minute and 5 seconds;
> FIBPlus open the same queries in 7 seconds.
> The test are made with 2 different version of the same program, only
> IBO/FIB Plus components are different. The connections are made in the
> same manner to the same database on the same PC.
> I have make some other test with different PC (from Celeron 700Mhz to
> Pentium IV 2,8Ghz) but the result is alwais the same IBO need more and
> more time to make the same operation.
> How this ?
> Do you think to make some test/correction/improvments for speed-up
> TIBOQuery at open time?
> Now i must solve this problem and if i can't see any
> different solution
> i must switch to FIBPlus with a lot of work for me.... FIB
> Plus haven't
> all the goodies that IBObject's have... but now the speed of
> application
> are a big problem.
> Kind regards,
> Enrico Raviglione.