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