Subject Re: [IBO] Re: TIB_Query.Prepare vs. TIBOQuery.Prepare
Author Helen Borrie
This was your original complaint:

"What I'd like to know is: why does it take a TIB_Query component
about 70 ticks to prepare the statement, whereas a TIBOQuery needs
almost 1200 ticks (!) to prepare the very same statement? I did not
mess around with any properties, just dropped the components on the form."

At 09:54 AM 6/11/2006, you wrote:
>No comments, explanations, or workarounds?
>
>So I have to conclude that this is a major flaw in the TIBOQuery component?

You didn't provide any environmental information but I'd suspect that
you have BDE artifacts hanging around, e.g dbtables in a uses clause
somewhere.

A *statement* is prepared. Whether it's implemented in a TIBOQuery
or a TIB_Query should be irrelevant....I would expect a lot of
overhead on a "SELECT *" query over a very wide structure in either
case; and the extra "noise" in the TDataset would be
perceptible...though not a 17-fold difference.

Could you put up a drop-dead simple demo project in the Files area of
the list, so someone could look at what's amiss?

>If so, this would deter me from using it at all. Which would make
>the entire IB Objects pretty useless (for me), since TDataSet
>compatibility is essential to all of my projects. I can hardly
>believe no one on this list ever encountered this problem...

You have now... :-)

>Solutions, anyone?

Let's find out what the problem is, first.

Helen