You can set the size of the client database-request statement cache using the -clstmtCacheSize parameter in the _DbParams VST or using PROMON. You can specify a value between 256 (default) and 30,000 bytes. If the database-request statement information for a client exceeds the value, then the information is stored in a temporary file, which slows down database operations. For optimal performance, Progress recommends that you set the client statement cache size value high enough to prevent triggering the creation of a temporary file.
Note: You do not receive a notification if the client statement cache has been exceeded. A temporary file appearing in your previously-specified directory is the only indicator, but this temporary file is deleted when the session ends.