Tim,

I assume you are using Firebird 1.0 or Interbase. I believe you are having
the same problem I had with the long delay when reading the "schema" data.
(My DB has 1500+ tables and took over 3 minutes with FB 1.0.)

If your "schema" data doesn't change often, check out/set the
SchemaCacheDir will limit your delays to ONCE per schema modification.

If you can, upgrade to Firebird 1.5. It has been modified to index the
internal tables in such a way as to speed up IBO's schema queries
dramatically. (My 3 minute delay with FB 1.0 is now sub-second with FB
1.5.)

Good Luck.

--Rhett

On 16 Sep 2003 17:53:45 -0000, <IBObjects@yahoogroups.com> wrote:
> ________________________________________________________________________
>
> Message: 7
> Date: Tue, 16 Sep 2003 14:36:06 +1000
> From: "Tim Knipe" <timk@...>
> Subject: Re: TIBOQuery to TClientDataSet really slow
>
> Thanks Helen,
>
> 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.
>
> Regards,
> Tim Knipe
>
>
>
>
> ________________________________________________________________________