Subject Schema Cache
Author mkl20uk
I need to operate across a low bandwidth connection and am using
TIB_ components only.

Is setting up schema caching as simple as

1 Setting Connection.SchemaCacheDir = <local directory>
2 Calling Connection.SchemaCache.Create( Connection )
3 Calling Connection.SchemaCache.CheckSchemaVersionTable (just to
make sure IBO$SCHEMA_VARSION exists).

What likely performance benefit is likely to be seen. If for
example, 4 VARCHAR(128) fields are being retrieved by selecting on
their primary key. If the low bandwidth connection is a 64k ISDN
connection. I know this is a difficult question to answer but I just
need to have a feel for the likely performance improvement that would
be seen.

Thanks in advance