[jira] [Resolved] (PHOENIX-1188) Performance regression for non-aggregate queries

["James Taylor (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-1188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor resolved PHOENIX-1188.
-----------------------------------

       Resolution: Fixed
    Fix Version/s: 4.1
                   3.1
                   5.0.0

> 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
>             Fix For: 5.0.0, 3.1, 4.1
>
>         Attachments: PHOENIX-1188.patch
>
>
> 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)