[PHOENIX-1188] Performance regression for non-aggregate queries

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.0, 4.1.0
• Fix Version/s: 3.1.0, 4.1.0
• Assignee: James R. Taylor
• Reporter: Mujtaba Chohan
• Created: 20/Aug/14 01:05
• Updated: 21/Nov/15 02:16
• Resolved: 21/Aug/14 15:19

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