[ https://issues.apache.org/jira/browse/IGNITE-4106?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15875007#comment-15875007 ]
ASF GitHub Bot commented on IGNITE-4106: ---------------------------------------- GitHub user AMashenkov opened a pull request: https://github.com/apache/ignite/pull/1556 IGNITE-4106: SQL: parallelize sql queries over cache local partitions Merged with IGNITE-1.9. You can merge this pull request into a Git repository by running: $ git pull https://github.com/gridgain/apache-ignite ignite-4106-1.9 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/ignite/pull/1556.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #1556 ---- commit 608032b900a51a7fba99e383c0fe0d8a37558cbb Author: AMRepo <andrey.mashen...@gmail.com> Date: 2017-02-20T18:24:29Z Implemented. commit b7c5ae313fa7c4cc6765e2f3ce8eb30d46c93f10 Author: AMRepo <andrey.mashen...@gmail.com> Date: 2017-02-20T19:53:33Z Merge remote-tracking branch 'apache/ignite-1.9' into ignite-4106-1.9 # Conflicts: # modules/indexing/src/main/java/org/apache/ignite/internal/processors/query/h2/IgniteH2Indexing.java # modules/indexing/src/main/java/org/apache/ignite/internal/processors/query/h2/opt/GridH2IndexBase.java # modules/indexing/src/main/java/org/apache/ignite/internal/processors/query/h2/twostep/GridMapQueryExecutor.java # modules/indexing/src/main/java/org/apache/ignite/internal/processors/query/h2/twostep/GridReduceQueryExecutor.java # modules/indexing/src/main/java/org/apache/ignite/internal/processors/query/h2/twostep/msg/GridH2QueryRequest.java # modules/indexing/src/test/java/org/apache/ignite/internal/processors/query/IgniteSqlSplitterSelfTest.java ---- > SQL: parallelize sql queries over cache local partitions > -------------------------------------------------------- > > Key: IGNITE-4106 > URL: https://issues.apache.org/jira/browse/IGNITE-4106 > Project: Ignite > Issue Type: Improvement > Components: SQL > Affects Versions: 1.7 > Reporter: Andrew Mashenkov > Assignee: Andrew Mashenkov > Labels: performance > Fix For: 1.9 > > Attachments: 1node-4thread.jfr, 4node-1thread.jfr > > > 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. -- This message was sent by Atlassian JIRA (v6.3.15#6346)