Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 0F162200B76 for ; Tue, 30 Aug 2016 23:27:23 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 0DA53160AC5; Tue, 30 Aug 2016 21:27:23 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 3FAA6160ABA for ; Tue, 30 Aug 2016 23:27:22 +0200 (CEST) Received: (qmail 84780 invoked by uid 500); 30 Aug 2016 21:27:21 -0000 Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.apache.org Delivered-To: mailing list dev@phoenix.apache.org Received: (qmail 84681 invoked by uid 99); 30 Aug 2016 21:27:21 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Aug 2016 21:27:21 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 486E52C1B79 for ; Tue, 30 Aug 2016 21:27:21 +0000 (UTC) Date: Tue, 30 Aug 2016 21:27:21 +0000 (UTC) From: "James Taylor (JIRA)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (PHOENIX-3227) OFFSET is very slow at scale MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Tue, 30 Aug 2016 21:27:23 -0000 [ 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)