[ODBC-397] Add Prepared Statement Cache to the Connector Created: 2023-10-11  Updated: 2023-10-11  Resolved: 2023-10-11

Status: Closed
Project: MariaDB Connector/ODBC
Component/s: General
Affects Version/s: None
Fix Version/s: 3.2.1

Type: New Feature Priority: Major
Reporter: Lawrin Novitsky Assignee: Lawrin Novitsky
Resolution: Fixed Votes: 0
Labels: None


 Description   

This should be LRU cache, and its use and options should be controlled by connstring options



 Comments   
Comment by Lawrin Novitsky [ 2023-10-11 ]

The cache is used by default. It's use can be turned off by setting cache size to 0. The size of cache can be set using connection string option PSCACHESIZE. The default value is 250
Another option is MAXCACHEKEY - it limits the size of key used to cache SSPS. Basically it's the length of query + lenght of Schema name + 1

Generated at Thu Feb 08 03:28:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.