phoenix-dev mailing list archives

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


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

View raw message