--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:

> At 01:20 PM 16/03/2004 +0000, you wrote:
> >How do i disable the schema load?
> >
> >I'm having terrible delays on remote access due to the load of the
> >database schema when i first open some dataset. This behavior was
> >not present in IBO 4.2. How can i disable it?
>
> It was present in IBO 4.2, as long as you had a value in the

SchemaCacheDir

> property of your TIB_Connection. Just delete it.
>

procedure TDat1.Loaded;
begin
inherited;
IBODatabase1.SchemaCacheDir := '';
end;

I already tried this, but it's still taking about 3 minutes to open
the first dataset in the application. The others are almost
instantly opened. Are you sure that making SchemaCacheDir equal
to '' disables the schema load?

I use TIBODatabase instead of TIB_Connection. Does it make some
difference?

>
> >By the way, what is it for?
>
> It is for caching the metadata on the client side. It makes for

slow

> loading at connection time, if you have changed the schema; but

in a

> stable system, it won't be loaded if the client's cache is up-to-

date. You

> would notice the cost of having no local schema on a slow network

but not

> so much on a fast one.
>
> Helen