I don't know what the purpose of the IBO$SCHEMA_CACHE table that you
are using.

Here's the way I do it. In the DataModuleCreate procedure I set the
SchemaCacheDir (for a TIBODatabase component) like this:
MyDb.SchemaCacheDir := ExtractFilePath(Application.ExeName)
+ 'Schema'. Our large application (12meg)is on a shared network drive
(Windows NT) over a 10/100 network, so one set of schema files are
shared by all the users (up to 50 at one time). When I have made
changes to the metadata I kick all the uses out of the app
(programatically), delete all the schema files, and run the
application again. This recreates all the schema files. The app takes
about 8-10 seconds to recreate the schema files and come up to the
main screen. After that it takes about 3 seconds to start (for me or
any user).

In the schema directory I see 8 tables (although some are empty) -
ClientSchmaVer.IBO, Computed.IBO, Defaults.IBO, IndexDefs.IBO,
ProcedureNames.IBO, TableFields.IBO, TableKeys.IBO, and
TableNames.IBO. You don't seem to have all the same tables. Maybe
that has something to do with your IBO$SCHEMA_CACHE table.

Also (obviously), the IB_Connection of all my IBO table, query, dsql,
and stored procedure components is the TIBODatabase component.

That's about all the help I can give you. Maybe one of the gurus (I'm
not one of them) can give you some more insight into your problem.

Stan Walker



--- In IBObjects@yahoogroups.com, "Enrico Raviglione"
<e.raviglione@i...> wrote:

> Hi Stan,
>
> I have try to use also TIBODatabase but i haven't see any

difference,

> perhaps i make something of wrong.
> I make this step:
> 1) in my DB i have created IBO$SCHEMA_CACHE table calling
> SchemaCache->CheckSchemaVersionTable();
> 2) in my Datamodule Constructor i set SchemaCacheDir of my

TIBODatabase

> to a local directory before make the connetion to my DB
>
> First time, when my program start it create my local SchemaCacheDir:
> into this directory i can see another dir named with the database

name,

> then into this last dir i can see 5 files (ClientSchemaVer.IBO,
> Computed.IBO, FieldDomains.IBO, ProcedureNames.IBO and

TableKeys.IBO)

> containing schema information of my db.
>
> Then if a launch my application a lot of time, i can see alwais the

same

> dir and files with the same creation date and time but the start-up

time

> of my app are alwais the same...
>
> SchemaCache help only if i have a slow connection or i can have some
> benefit also if i have a 100Mb lan connection with my server ?
>
> Bye,
> Enrico.
>
>
> -----Messaggio originale-----
> Da: stanw1950 [mailto:stanw@e...]
> Inviato: mercoledì 2 luglio 2003 16.14
> A: 'IBObjects@yahoogroups.com'
> Oggetto: R: [IBO] Re: FW: IBO seems slower for some things compared

with

> the BDE
>
>
> I use a TIBODatabase component with the SchemaCacheDir property and
> it helps a lot. I don't use a TIB_Connection, so I can't help you
> there.
>
> Stan Walker