[
https://issues.apache.org/jira/browse/PHOENIX-1564?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14260356#comment-14260356
]
Mujtaba Chohan commented on PHOENIX-1564:
-----------------------------------------
Scan on 4.2 branch is very slightly slow compared to 4.3-SNAPSHOT (4.0 branch)
which gets more evident when time is in milliseconds. It's *not* related to
reverse scan. See the following table with query times with and without reverse
scan for multiple runs:
||Query || Time in MS using 4.2 branch || Time in MS using 4.3-SNAPSHOT (4.0
branch) ||
|select * from WIDE_PK limit 10 | 62, 63, 80, 81, 95 | 29, 31, 34, 38, 38|
|select * from WIDE_PK order by mypk DESC limit 10 | 59, 60, 66, 67, 71 | 28,
29, 30, 34, 37|
I'll add 4.2.1 to run as well.
> Investigate performance of reverse scan
> ---------------------------------------
>
> Key: PHOENIX-1564
> URL: https://issues.apache.org/jira/browse/PHOENIX-1564
> Project: Phoenix
> Issue Type: Bug
> Reporter: James Taylor
>
> Based on latest perf numbers, the reverse scan looks to be 4x slower than
> previous releases. Needs to be investigated.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
