Subject | Re: [IBO] Re: TIB_Query.Prepare vs. TIBOQuery.Prepare |
---|---|
Author | Helen Borrie |
Post date | 2006-11-06T00:19:40Z |
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:
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?
Helen
"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?You didn't provide any environmental information but I'd suspect that
>
>So I have to conclude that this is a major flaw in the TIBOQuery component?
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 makeYou have now... :-)
>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...
>Solutions, anyone?Let's find out what the problem is, first.
Helen