Progress
Startup Command and Parameter
Reference
Schema Field Cache Size (-fc)
num-entries
The number of entries in the schema field cache.
Use Schema Field Cache Size (-fc) to change 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 Progress 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.
Progress uses approximately 150 additional bytes of memory per schema field cache entry used. Because memory is allocated when required, unused entries produce minimal overhead.
If you set the value to 0, Progress disables schema field caching.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |