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

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

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration