[jira] [Commented] (PHOENIX-3227) OFFSET is very slow at scale

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

    [ 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)