 |  LoginProducts  SalesSupportDownloadsAbout |
| Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 Manual for RAD Studio XE (Delphi) » Component Reference » TEDBSession » SQLStmtCacheSize Property |
SQLStmtCacheSize Propertyproperty SQLStmtCacheSize: Integer
Usage
Use the SQLStmtCacheSize property to specify how many SQL statements can be cached in memory for the duration of the session. Caching SQL statements improves the performance of ElevateDB by avoiding very expensive preparation/un-preparation cycles. The default value is 0, which means that SQL statements will not be cached for the session.
The maximum number of open SQL statements per connection is 2048, so you should not set the statement cache size that high. Also, the SQL statement cache size is a per-open-database setting.
More Support Options
This web page was last updated on Tuesday, April 23, 2024 at 09:24 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ?  E-mail us at info@elevatesoft.com |
