Schema Field Cache Size (-fc)

Use Schema Field Cache Size (-fc) to change the number of entries in the schema field cache.

Operating system and syntax UNIX / Windows -fc num-entries
Use with Maximum value Minimum value Single-user default Multi-user default
Client Session — 0 128 128
num-entries
The number of entries in the schema field cache.

For example, you might increase the size if you retrieve large numbers of fields from your database. The schema field cache reduces the time required to compile SQL queries by storing schema field information in memory. For best results, set this parameter to the total number of fields retrieved from the database.

If you set the value to 0, OpenEdge disables schema field caching.

OpenEdge uses approximately 150 additional bytes of memory per schema field cache entry used. Because memory is allocated when required, unused entries produce minimal overhead.