Uploaded image for project: 'MariaDB Connector/C++'
  1. MariaDB Connector/C++
  2. CONCPP-111

Prepared Statement Cache

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.1.2
    • 1.1.3
    • General
    • None

    Description

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

      Attachments

        Activity

          Lawrin Lawrin Novitsky added a comment -

          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)
          Lawrin Lawrin Novitsky added a comment - 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)

          People

            Lawrin Lawrin Novitsky
            Lawrin Lawrin Novitsky
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.