[ https://issues.apache.org/jira/browse/PHOENIX-76?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13921795#comment-13921795 ]
Hudson commented on PHOENIX-76: ------------------------------- FAILURE: Integrated in Apache Phoenix - Branch:4.0 #35 (See [https://builds.apache.org/job/Phoenix-4.0/35/]) PHOENIX-76 (anoopsamjohn: rev 348b7517ade37b3e8b879899b3b3a3729efcb63a) * phoenix-core/src/main/java/org/apache/phoenix/iterate/ParallelIterators.java * phoenix-core/src/main/java/org/apache/phoenix/filter/ColumnProjectionFilter.java PHOENIX-76 (anoopsamjohn: rev 2ca85ab681f3080e52db632b1a78d45445fd9cea) * phoenix-core/src/main/java/org/apache/phoenix/iterate/ParallelIterators.java PHOENIX-76 (anoopsamjohn: rev 3f44a215f9f56476c76868de770a28db0d65f0b0) * phoenix-core/src/main/java/org/apache/phoenix/iterate/ParallelIterators.java PHOENIX-76 Fix perf regression due to PHOENIX-29 (JamesTaylor) (jamestaylor: rev 2581c20fba120466e4d1337e6ba086a435a07f2a) * phoenix-core/src/main/java/org/apache/phoenix/iterate/ParallelIterators.java > Fix perf regression due to PHOENIX-29 > ------------------------------------- > > Key: PHOENIX-76 > URL: https://issues.apache.org/jira/browse/PHOENIX-76 > Project: Phoenix > Issue Type: Bug > Affects Versions: 3.0.0 > Reporter: James Taylor > Assignee: Anoop Sam John > Fix For: 3.0.0 > > Attachments: PHOENIX-76.patch, patch.diff > > > Many queries got slower as a result of PHOENIX-29. There are a few simple > checks we can do to prevent the adding of the new filter: > - if the query is an aggregate query, as we don't return KVs in this case, so > we're only doing extra processing that we don't need. For this, you can check > statement.isAggregate(). > - if there are multiple column families referenced in the where clause, as > the seek that gets done is better in this case because we'd potentially be > seeking over an entire stores worth of data into a different store. -- This message was sent by Atlassian JIRA (v6.2#6252)