Subject Re: [IBO] Speed difference between TIBQuery and TIB_Query?
Author Helen Borrie
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 database.
>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 correctly.
>Any ideas? Why would IBObjects v4.3 be so much slower?

If you are using an IB_Query to run a server-side process, then you have
chosen the slowest possible way to run a server-side process with IBO.

Additionally, if this process is being done as the first thing on
connecting to a database with a lot of metadata, then you are getting a
large amount of on-connection behaviour with IBO, that IBX doesn't do.

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

Helen