Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-4106

SQL: parallelize sql queries over cache local partitions

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.7
    • 1.9
    • sql

    Description

      If we run SQL query on cache partitioned over several cluster nodes, it will be split into several queries running in parallel. But really we will have one thread per query on each node.
      So, for now, to improve SQL query performance we need to run more Ignite instances or split caches manually.

      It seems to be better to split local SQL queries over cache partitions, so we would be able to parallelize SQL query on every single node and utilize CPU more efficiently.

      Attachments

        1. 1node-4thread.jfr
          1.55 MB
          Andrey Mashenkov
        2. 4node-1thread.jfr
          4.22 MB
          Andrey Mashenkov

        Issue Links

          Activity

            People

              amashenkov Andrey Mashenkov
              amashenkov Andrey Mashenkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: