Subject Re: TIBOQuery to TClientDataSet really slow
Author lalopus
About my last message, it's not all metadata that comes from the
database, but index information and that type of thing.
It's been some time since I looked at this, so please accept my
apologies for the inaccuracy.

Regards
Eduardo

--- In IBObjects@yahoogroups.com, "lalopus" <eduardo@p...> wrote:
> Hi, I'm having the same problem for some time now.
> Some research we did showed that when the ClientDataSet is opened,
> ALL metadata information is "pulled" from the database, and this
is
> the problem (I think the IBODatabase object was doing this).
> One likely solution would be to use the SchemaCacheDir property of
> the IBODatabase object. This way that information would be saved
to
> disk. The drawback is that you should set some version control on
> the database, so the IBODatabase object knows when to look for
that
> information again. In our case this wasn't practical, so we're
still
> waiting for a definitive solution.
>
> regards
> Eduardo
>
>
>
> --- In IBObjects@yahoogroups.com, "Tim Knipe" <timk@p...> wrote:
> > Using IBO4 on Delphi 7 with Interbase 5.6, I've got a TIBOQuery
> > connected to a TClientDataSet via a TDataSetProvider. For some
> reason
> > this takes over a minute (on a P4 2.4Ghz, 1GB RAM) to fill the
> > TClientDataSet, even if there is only 1 row in the TIBOQuery.
> >
> > Using IBX in a similar way is instantaneous. However, I have to
> use IBO
> > for this project.
> >
> > Has anyone seen this problem and is there anything I can do
about
> it to
> > speed things up?
> >
> > I tried various combinations of the following properties with no
> > improvement;
> > CachedUpdates
> > FetchWholeRows
> > KeyLinksAutoDefine
> > ReadOnly
> > Unidirectional
> >
> >
> > TIA
> > Tim Knipe