| Subject | Re: [IBO] Schemacache |
|---|---|
| Author | Michel LE CLEZIO |
| Post date | 2018-03-29T12:01:30Z |
Thanks Mikey for answering
....
yes, what you write here, is what i expected.
But if you use the IB_Connection (and not IBODatabase) then
it seems to be created everytime also if the
SchemaCacheDir:= is empty.
And if you have a database with 1000ts of tables, but only use some
of them in the client, it uses
many seconds to save all the chemadata files on the client computer.
This issue makes the user experience to start a programm very bad.
In former versions i didn't had this problem.
I cannot say, what newer version changed this behaviour.
But in the meantime this is very boring.
best regards
Gerhard
Hello,
May be I'm wrong, but by default, the
IBODatabase1.SchemaCacheDir:= is emptySo no files are created on client side...
Files are created only if it is not empty...
IBODatabase1.SchemaCacheDir:='C:\MYSOFT DIRECTORY\SCHEMA CACHE DIR';
If the files doesn't exists, the first connection, will produce the files... After for other connection, those files will be used (it's faster tu uses them on the client, than to load informations on the server).But if the schema of your database change, delete them, in order to upgrade them at the next connection...
This is how I've understand the SchemaCacheDir property...
With best Regards,Mikey
Le mardi 27 mars 2018 10:59:41 CEST, Gerhard Knapp gerhard.knapp@... [IBObjects] <IBObjects@yahoogroups.com> a écrit :
sorry if i ask a stupid question...
But is it possible to get a firebird connection without creating the schemacache on the client side?
Even i let the Schemacacedir empty i get a lot of chemacache data to the client.
(needs many seconds of waiting)
best regards
Gerhard