Subject | Re: TIB_Query vs. TIBOQuery??? |
---|---|
Author | gsndelphicoder |
Post date | 2011-02-23T14:29:23Z |
Thank you Carlos for your response!
I can use a TDatabase and TwwQuery (InfoPower) to run the same query and there is no lag time upon initial opening of the query. This is also true of a TIB_Database and TIB_Query. The only time a lag in speed is detected is upon initial opening of the SQL query with a TIBOQuery component...
> TIBOQuery is derived from the TDataset class, but internally, it usesI have tried this, but to no avail. There were only minor differences between the two and all shared properties are now set the same. The TIBOQuery still take 6-8 seconds to open after the TIB_Database connection has been reset. Note: After the initial opening of the TIBOQuery, subsequent openings are instantaneous. This issue is only with the first time the query is opened.
> a TIB_Query (check the InternalDataset property of TIBOQuery).
>
> The default value for some of the TIBOQuery properties are not the
> same as the default values of TIB_Query properties. Maybe the
> difference of performance you are feeling is due to different
> configuration in some of the common properties of both components. Try
> to compare them and test with different configs.
I can use a TDatabase and TwwQuery (InfoPower) to run the same query and there is no lag time upon initial opening of the query. This is also true of a TIB_Database and TIB_Query. The only time a lag in speed is detected is upon initial opening of the SQL query with a TIBOQuery component...
> BTW, afair, there is an extra ReportBuilder pipeline component that isI have looked into this. I will try to get this running. The code hasn't been updated for several years...
> able to connect direct to TIB_Query. Check old messages of this list
> to get more information about it.