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 )
ITALY
TEL. +39 0125 253235
FAX +39 0125 253271
www.ideasistemi.it
e.raviglione@...






-----Messaggio originale-----
Da: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] Per
conto di Lester Caine
Inviato: martedì 24 maggio 2005 17.26
A: 'IBObjects@yahoogroups.com'
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
like?

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
InterBase
without the need for BDE, ODBC or any other layer.
________________________________________________________________________
___
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !

Yahoo! Groups Links