Subject R: [IBO] for Jason: TIBOQuery vs. TFIBDataset speed test
Author Enrico Raviglione
Hi Lester,

I have sended my e-mail to Jason only because in the last 2-3 month i
have already sended to him a lot of other e-mail and an example.

No problem for Delphi i use only C++Builder.

Here my first e-mail:

>>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 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 made 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 "prepare and
open" operation.
>>How this ?
>>Do you think to make some test/correction/improvments for speed-up
TIBOQuery at open time?

I mailed you privately the download address of my example.

Best Regards.

Enrico Raviglione

IDEA Sistemi s.n.c.
Via Burolo, 30
10015 IVREA ( TO )
TEL. +39 0125 253235
FAX +39 0125 253271

-----Messaggio originale-----
Da: [] Per
conto di Lester Caine
Inviato: martedì 24 maggio 2005 17.26
A: ''
Oggetto: Re: [IBO] for Jason: TIBOQuery vs. TFIBDataset speed test

Enrico Raviglione wrote:

> Hi Jason,
> Now we are arrived at 24.05.2005, my first e-mail are dated 18.03.2005

> then i must know if you can do something about this problem. If i can
> help you in any manner tell me what i must do ... My time are finished

> ...

I see that your emails have been direct to Jason which is why we have
not been 'in the loop' and able to help! I lost a block of email about
the time of your original post so don't have it.

None of my applications take longer than a few seconds to connect, so
there must be something in your setup that is not quite right. Having
said that I killed most of the legacy compatible stuff early on.

Following on from SET's questions.

If you open the database using IB_SQL what are the connection times

I'd say drop a copy of your tests to me, but I don't have Delphi here
only Builder - but if the database is slow opening in IB_SQL then I'm
quite happy to have a look at it.

Lester Caine
L.S.Caine Electronic Services

IB Objects - direct, complete, custom connectivity to Firebird or
without the need for BDE, ODBC or any other layer.
___ - your IBO community resource for Tech Info
keyword-searchable FAQ, community code contributions and more !

Yahoo! Groups Links