Subject | Schema Cache |
---|---|
Author | mkl20uk |
Post date | 2002-03-02T20:26:08Z |
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
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