Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
3.2.3
-
None
Description
Prepared statement cache is controlled by 2 connection string options - PSCACHESIZE for the size of cache and MAXCACHEKEY for the max length of the key for the cached PS that effectively limits the maximum length of the query string , that would be cached. 0 for any of these parameters turns the use of the cache off.
Setup dialog is missing fields for both of these parameters
The corresponding fields have been introduced.
"Max query of the query length to cache" is in fact limits max length of the key the cache uses to store PS, and that is the length of the query itself, + length of the schema name + 1
There is a tooltip on the small button to the right from edit's label.