[PHOENIX-3227] OFFSET is very slow at scale

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Assignee: Unassigned
• Reporter: Lars Hofhansl
• Created: 30/Aug/16 20:55
• Updated: 31/Aug/16 08:06
• Resolved: 31/Aug/16 08:06

Description

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.