Subject | R: [IBO] Re: FW: IBO seems slower for some things compared with the BDE |
---|---|
Author | Enrico Raviglione |
Post date | 2003-07-02T16:51:17Z |
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@...]
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
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@...]
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