Subject | Re: TIBOQuery to TClientDataSet really slow |
---|---|
Author | lalopus |
Post date | 2003-09-17T13:56:30Z |
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
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