Uploaded image for project: 'MariaDB Connector/C'
  1. MariaDB Connector/C
  2. CONC-12

Support hash based aggregation method for GROUP BY

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • None
    • None
    • None
    • None

    Description

      The current sort based GROUP BY implementation performs badly when source data is large and expected output is small. An alternative method, supported by Oracle, Postgres, SQL Server, etc. is to use hash aggregation, as described here: http://blogs.msdn.com/b/craigfr/archive/2006/09/20/hash-aggregate.aspx

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          mjohnston Mathew Johnston created issue -
          mjohnston Mathew Johnston added a comment -

          Shoot! Created against the wrong project - should be against the server. I don't seem to have any way of moving it. Apologies!

          mjohnston Mathew Johnston added a comment - Shoot! Created against the wrong project - should be against the server. I don't seem to have any way of moving it. Apologies!
          mjohnston Mathew Johnston added a comment -

          Please close this one - I'll open another against the right project. Thanks!

          mjohnston Mathew Johnston added a comment - Please close this one - I'll open another against the right project. Thanks!
          elenst Elena Stepanova added a comment -

          Duplicate of MDEV-4166

          elenst Elena Stepanova added a comment - Duplicate of MDEV-4166
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Resolution Duplicate [ 3 ]
          Status Open [ 1 ] Closed [ 6 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow defaullt [ 26207 ] MariaDB connectors [ 54885 ]
          julien.fritsch Julien Fritsch made changes -
          Workflow MariaDB connectors [ 54885 ] MariaDB v4 [ 160902 ]

          People

            ratzpo Rasmus Johansson (Inactive)
            mjohnston Mathew Johnston
            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.