Try OpenEdge Now
skip to main content
Startup Command and Parameter Reference
Startup Parameter Descriptions : Schema Field Cache Size (-fc)

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
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.