Icon FuncProcCacheSize Property

property FuncProcCacheSize: Integer

Usage

Use the FuncProcCacheSize property to specify how many functions/procedures can be cached in memory for the duration of the session. Caching functions/procedures improves the performance of ElevateDB by avoiding very expensive preparation/un-preparation cycles. The default value is 0, which means that functions/procedures will not be cached for the session.

Information The maximum number of open functions/procedures per connection is 2048, so you should not set the function/procedure cache size that high. Also, the function/procedure cache size is a per-open-database setting.
Image