[
https://issues.apache.org/jira/browse/PHOENIX-3227?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15450197#comment-15450197
]
James Taylor commented on PHOENIX-3227:
---------------------------------------
Yes, that's what I expected. FYI, we do push the OFFSET to the server when ever
possible, but you still have to step through row by row (except on the server
and then at least you don't return all the data back to the client). Also, the
slowness is due to the query needing to be executed serially.
> OFFSET is very slow at scale
> ----------------------------
>
> Key: PHOENIX-3227
> URL: https://issues.apache.org/jira/browse/PHOENIX-3227
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: Lars Hofhansl
>
> Perhaps this one is also expected since it is the client who has to count off
> rows. In any case, we tried with an OFFSET of just 10000000 and that took
> 46s, regardless of how big the cluster at our disposal was.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
