[CONCPP-111] Prepared Statement Cache Created: 2022-11-28  Updated: 2023-12-04  Resolved: 2023-10-11

Status: Closed
Project: MariaDB Connector/C++
Component/s: General
Affects Version/s: 1.1.2
Fix Version/s: 1.1.3

Type: New Feature Priority: Major
Reporter: Lawrin Novitsky Assignee: Lawrin Novitsky
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: 0d
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

The code is mostly there, but was never tested, and it needs some adaptation before that



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

ealization has been moved from a class, that existed in the source tree, but was
not used, to a external class template. The cache is controlled by
following connection string options:

  • cachePrepStmts - enables/disables use of cache, by default is false
  • prepStmtCacheSize - sets the size of cache, by default 250
  • prepStmtCacheSqlLimit - allows to change maximum size of the query,
    that will be cached. This value consists of length of query itself +
    length of schema name + 1
    Cache will be enables only of if useServerPrepStmts is selected.
    Test of PS caching has been added, however it can fail if run on not
    exclusive server(i.e. used by other apps in parallel)
Generated at Thu Feb 08 03:08:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.