Subject | Re: [IBO] TIBOQuery to TClientDataSet really slow |
---|---|
Author | Helen Borrie |
Post date | 2003-09-16T04:52Z |
At 02:36 PM 16/09/2003 +1000, you wrote:
it through to here?
If yes, send it to helebor@..., as tpg is a bit flaky.
Helen
>Thanks Helen,Assuming you're in Oz, do you want to gbak the database, zip it up and send
>
>I've tried a minimal test application similar to the one you describe.
>The only difference, I was using TIB_Connection, but have now tried both
>TIB_Connection and TIBODatabase with the same effect.
>
>Opening the TIBOQuery is fast. Activating the TClientDataSet takes a
>minute or more - the first time. After that it's fast, even if you
>change the TIBOQuery. If you disconnect the TIB_Connection or
>TIBODatabase, then you incur the minute delay the first time
>TClientDataSet tries to grab the data.
>
>I tried connecting to SAMPLE.GDB from the link you provided and it
>worked fine, instantaneous.
>
>The DB I'm working with is about 80MB with hardly any data and about 300
>tables, 1200 procedures and 840 triggers.
it through to here?
If yes, send it to helebor@..., as tpg is a bit flaky.
Helen