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.