Subject Re: [IBO] Speed difference between TIBQuery and TIB_Query?
Author sgharp
--- In, Helen Borrie <helebor@t...> wrote:
> At 03:42 PM 21/05/2004 -0400, you wrote:
> >Hi All,
> >
> >I have a short utility that I'm writing to run against a Firebird
> >Using TIBQuery components (that come with D7), I can run the
process in 11
> >seconds. Using the exact same code but with TIB_Query
components, it takes
> >2 minutes and 3 seconds. I'm sure I'm not setting something up
> >Any ideas? Why would IBObjects v4.3 be so much slower?

> Help us to help you by providing some information about what
you're trying
> to do...

I'm doing a query on a table with about 1500 records and then, for
each record, performing a calculation which requires other queries
(some joins) agains other tables to calculate a number and lastly,
update the original table with this number. For each record in the
first table, I might have to do from about 1 - 20 recursions. There
are 3 static query objects involved plus one query object that is
created dynamically within a recursive procedure.

I'm thinking that the performance difference must be a configuration
issue. If TIB_Query was that much slower than TIBQuery, it wouldn't
seem that IBObects would be so popular. 11 seconds compared to more
than 2 minutes is significant.