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

improve performance reading big resultset

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 3.1.0
    • performance
    • None

    Description

      Actual implementation check column metadata for each decoding value :
      getInt() will check column medatadata to check column datatype, signed/unsigned value, ... for each decoding.

      When having lots of rows, that represent a significant amount of time.
      A better solution would be to set a decoding method reference depending on datatype, permitting to decode value.
      This need benchmark, because method reference use might prevent better performant

      Attachments

        Activity

          diego dupin Diego Dupin created issue -
          diego dupin Diego Dupin made changes -
          Field Original Value New Value
          Fix Version/s 3.1 [ 26083 ]
          diego dupin Diego Dupin made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          diego dupin Diego Dupin made changes -
          issue.field.resolutiondate 2022-09-30 08:28:44.0 2022-09-30 08:28:44.486
          diego dupin Diego Dupin made changes -
          Component/s performance [ 14519 ]
          Fix Version/s 3.1.0 [ 28435 ]
          Fix Version/s 3.1 [ 26083 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]

          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:

              Git Integration

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