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 D0496200BC2 for ; Thu, 17 Nov 2016 14:40:20 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id CF406160B0B; Thu, 17 Nov 2016 13:40:20 +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 49E73160AFF for ; Thu, 17 Nov 2016 14:40:20 +0100 (CET) Received: (qmail 21586 invoked by uid 500); 17 Nov 2016 13:40:19 -0000 Mailing-List: contact user-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ignite.apache.org Delivered-To: mailing list user@ignite.apache.org Received: (qmail 21576 invoked by uid 99); 17 Nov 2016 13:40:19 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Nov 2016 13:40:19 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id CEBFB180149 for ; Thu, 17 Nov 2016 13:40:18 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.174 X-Spam-Level: ** X-Spam-Status: No, score=2.174 tagged_above=-999 required=6.31 tests=[DKIM_ADSP_CUSTOM_MED=0.001, NML_ADSP_CUSTOM_MED=1.2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_SOFTFAIL=0.972, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id cov33OQdhQYt for ; Thu, 17 Nov 2016 13:40:16 +0000 (UTC) Received: from mbob.nabble.com (mbob.nabble.com [162.253.133.15]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id DAD9B5F295 for ; Thu, 17 Nov 2016 13:40:15 +0000 (UTC) Received: from static.162.255.23.37.macminivault.com (unknown [162.255.23.37]) by mbob.nabble.com (Postfix) with ESMTP id B98CE362D3C1 for ; Thu, 17 Nov 2016 05:30:09 -0800 (PST) Date: Thu, 17 Nov 2016 06:40:14 -0700 (MST) From: vdpyatkov To: user@ignite.apache.org Message-ID: <1479390014434-9046.post@n6.nabble.com> In-Reply-To: <1479373608359-9037.post@n6.nabble.com> References: <1479373608359-9037.post@n6.nabble.com> Subject: Re: SELECT with ORDER BY and pagination MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit archived-at: Thu, 17 Nov 2016 13:40:21 -0000 Hi, Lock at the method (o.a.i.cache.query.SqlFieldsQuery#setPageSize), that allow to set sql page size. If you are going through cursor (result of cache.query()) or executing "getAll" then you get all result data. Client gets data into page range, if used cursor (and sent request to the next part of data if needed). [1]: https://apacheignite.readme.io/docs/sql-queries -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SELECT-with-ORDER-BY-and-pagination-tp9037p9046.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.