[
https://issues.apache.org/jira/browse/PHOENIX-3227?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15451521#comment-15451521
]
Ankit Singhal commented on PHOENIX-3227:
----------------------------------------
Yes, the performance is expected.
but I think for real use-cases , user will not pass such high offset(10M+) as
query result sets generally ranges between 1-100k.
For serial flat queries without filters, GuidePosts could be an option but the
row count calculated are not actual and not available in realtime.
So, IMO we can close this for now.
> 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)
