[
https://issues.apache.org/jira/browse/PHOENIX-1188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-1188:
----------------------------------
Description:
Performance for non-aggregate queries is 4X+ slower. Commit that caused this
regression (PHOENIX-539) :
https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=commit;h=ec1b76ab28880d548c8061a6dcb80a6fe0d97ed6
FYI [~gabriel.reid]
Performance is slow even if no rows are returned.
Sample perf run:
http://phoenix-bin.github.io/client/performance/phoenix-20140819014309.htm
Query:
select a,b,c,d,e,f from TABLE_1CF where B>1000 and B<2000 and f>1000 and f<2000
was:
Performance for non-aggregate queries is 4X+ slower. Commit that caused this
regression (Phoenix-539) :
https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=commit;h=ec1b76ab28880d548c8061a6dcb80a6fe0d97ed6
FYI [~gabriel.reid]
Performance is slow even if no rows are returned.
Sample perf run:
http://phoenix-bin.github.io/client/performance/phoenix-20140819014309.htm
Query:
select a,b,c,d,e,f from TABLE_1CF where B>1000 and B<2000 and f>1000 and f<2000
> Performance regression for non-aggregate queries
> ------------------------------------------------
>
> Key: PHOENIX-1188
> URL: https://issues.apache.org/jira/browse/PHOENIX-1188
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 3.1, 4.1
> Reporter: Mujtaba Chohan
> Assignee: James Taylor
>
> Performance for non-aggregate queries is 4X+ slower. Commit that caused this
> regression (PHOENIX-539) :
> https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=commit;h=ec1b76ab28880d548c8061a6dcb80a6fe0d97ed6
> FYI [~gabriel.reid]
> Performance is slow even if no rows are returned.
> Sample perf run:
> http://phoenix-bin.github.io/client/performance/phoenix-20140819014309.htm
> Query:
> select a,b,c,d,e,f from TABLE_1CF where B>1000 and B<2000 and f>1000 and
> f<2000
--
This message was sent by Atlassian JIRA
(v6.2#6252)
