Local schema caching
- Last Updated: January 17, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
Local schema caching
The ability to store schema definitions in a local file allows you to access them more quickly. Running DataServer applications with a local schema cache in addition to a schema holder results in better performance.
An ABL SAVE CACHE COMPLETE statement
creates a binary file that contains the entire schema for an OpenEdge database.
Use the following syntax to create a cache file for a connected
schema holder:
SAVE CACHE COMPLETE schema-holder-name TO filename.
For example, the following statement creates a cache file named ocache for
the oholder schema holder:
SAVE CACHE COMPLETE oholder TO ocache.
To use the cache file for a schema holder, specify the -cache parameter
and the cache filename when you connect to the schema holder. For
example, the following CONNECT statement connects
the Oracle database with the schema holder and tells ABL to use
the cache file:
CONNECT oholder -RO -db oradb -U scott -P tiger -cache ocache.
If you make any changes to the schema holder, create a new cache file for the schema holder.
For more information, see Develop ABL Applications and the "SAVE CACHE Statement" reference entry in ABL Reference.