Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-397

Add Prepared Statement Cache to the Connector

Details

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

    Description

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

      Attachments

        Activity

          Lawrin Lawrin Novitsky added a comment -

          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

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

          People

            Lawrin Lawrin Novitsky
            Lawrin Lawrin Novitsky
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.