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

Some performance improvements

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.1.12
    • Fix Version/s: 3.1.13
    • Component/s: General
    • Labels:
      None

      Description

      This is to separate possible performance improvements described in ODBC-313 from original core issue (redundant call of SQLPrimaryKeys by the code generated by Embarcadero, or does it make more sense to talk about Interbase).
      In this way, this ticket is dedicated to following things
      1) Suboptimal tx_isolation query
      2) That INFORMATION_SCHEMA query should use '=' rather than 'LIKE' - those parameters of SQLPrimaryKeys may not be a pattern
      3) Statement reset can be optimized. They are issued on cursor closing( SQLFreeStmt with SQL_CLOSE), and in most cases are not needed
      4) Queries, issued by the connector should be assembled in batches, if possible. This is going mostly about configuring the session at connect time.
      5) Use session tracking feature of servers. That makes item 1 less relevant, but not all servers out there support tracking.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Lawrin Lawrin Novitsky
              Reporter:
              Lawrin Lawrin Novitsky
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration