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 empty

So 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