Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-880

metadata query performance correction

    XMLWordPrintable

Details

    Description

      Metadata query can sometime do full table scan.
      To avoid that query must be slightly be simplifyed.
      Since tables in mariadb cannot have no catalog, a simplification of query with empty catalog (not null) will be considered as no-op, returning empty resultset as expected. This will permit condition to always have strict equality (or like if needed), avoiding fulltable scan.

      Attachments

        Activity

          People

            diego dupin Diego Dupin
            diego dupin Diego Dupin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 1d
                1d

                Git Integration

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