phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3227) OFFSET is very slow at scale
Date Tue, 30 Aug 2016 21:27:21 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-3227?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15450202#comment-15450202
] 

James Taylor commented on PHOENIX-3227:
---------------------------------------

[~ankit@apache.org]

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

Mime
View raw message