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 370A8200BDC for ; Wed, 30 Nov 2016 06:43:48 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 2D796160B23; Wed, 30 Nov 2016 05:43:48 +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 744F0160B15 for ; Wed, 30 Nov 2016 06:43:47 +0100 (CET) Received: (qmail 62683 invoked by uid 500); 30 Nov 2016 05:43:46 -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 62673 invoked by uid 99); 30 Nov 2016 05:43:46 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 30 Nov 2016 05:43:46 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id ED7A5C0A27 for ; Wed, 30 Nov 2016 05:43:45 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.199 X-Spam-Level: * X-Spam-Status: No, score=1.199 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id j567cUa9riCp for ; Wed, 30 Nov 2016 05:43:43 +0000 (UTC) Received: from mail-io0-f169.google.com (mail-io0-f169.google.com [209.85.223.169]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id C743E5F5F7 for ; Wed, 30 Nov 2016 05:43:42 +0000 (UTC) Received: by mail-io0-f169.google.com with SMTP id j65so331626162iof.0 for ; Tue, 29 Nov 2016 21:43:42 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=LIeG8GDyEkVY5iwngQXRRy3jKdUyJsFELgQLhic+ObU=; b=BgrUD61pFY8kvWMSUz+6xYHtB+g4s8bvQbpMpr79WKF09FwQJperx9kNPo3QFcGLgF Tb4Azz1NfYQp2HUKKNiP9PvgZK5Wns3SWctjTwse2l17V3gvuWGiEHBb834R57Aqgbts c+CofqyqGjWNZWgJ/BvjO4tpa7lWBoz3R2jnd9gNRDnX4vL+Z5ry9sMESb6LW7zOA1AS tpLR3oRh99vvkKMEsXPJnInEBgCeEpovj/gpINnWVSMKWATgj1A//FVeCh6f+yakKRLv 9yNDYqHAqqoSy5MiqVZIcd+lY4RRQvf1lOM992Uf/41JcsfEvb3V6t4acMhXjv9Bky/D vavA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=LIeG8GDyEkVY5iwngQXRRy3jKdUyJsFELgQLhic+ObU=; b=D2XDx0bS49gsJsVZFMdB5XsppKp1Zyn/1pp/iJYkUEwaP/e1EE4LTS6PKOu+Nn731O YI1JP4dIr41WmVt63IryP5JVkwRTX2Nfb3qus+NXZF49IQMqwjRr2FPkdrRhx05GAbUd sYj7P1KQIMAgJC5u3f+aJ5yhrrx+nZHiUCTHgtuBmhrBxNDGON9zum36F4iisRBuCVZC 9HgEGQ0YodLM28/dk5TeX8LXt2gpgEPcwGvDxlUxp8349Ea9i9J2KnpKW0EOYJba5BQ5 r3GbdB1M0oDi1WoMfcS0FM4ZF7JoUWqiW4ETn4QF6rjJhE7+zaAz+Eg1VuK5pVWyaVln se1A== X-Gm-Message-State: AKaTC02YDOBTEaODGgqWhUL/z1/AK10Ys41Kn8s0jgQIqJ497WD6gsE9ngZOH8nLP43SALzz+7nFe2P7Djb0sQ== X-Received: by 10.36.123.82 with SMTP id q79mr26705089itc.25.1480484621367; Tue, 29 Nov 2016 21:43:41 -0800 (PST) MIME-Version: 1.0 Received: by 10.107.59.15 with HTTP; Tue, 29 Nov 2016 21:43:00 -0800 (PST) In-Reply-To: <1479243682671-9007.post@n6.nabble.com> References: <1479243682671-9007.post@n6.nabble.com> From: Anil Date: Wed, 30 Nov 2016 11:13:00 +0530 Message-ID: Subject: Re: Limit the number of results query To: user@ignite.apache.org Content-Type: multipart/alternative; boundary=001a11474ba4f3c03605427e2fb3 archived-at: Wed, 30 Nov 2016 05:43:48 -0000 --001a11474ba4f3c03605427e2fb3 Content-Type: text/plain; charset=UTF-8 HI Val, thanks for response. OOO is on server. Does server have separate memory blocks for each query results ? how does that work when number of number of queries executed in parallel ? Thanks On 16 November 2016 at 02:31, vkulichenko wrote: > Do you mean OOM on the server or on the client? On server you indeed will > need some spare space for any ongoing operations (not only queries, > actually). You should make sure that this space is enough for you load. On > client you should not get OOM because results are sent in pages (unless you > call QueryCursor.getAll). If you iterate through the cursor, you will have > only one page in client memory at a time which is 1024 rows by default. > > Query cancellation and timeout will be available in 1.8: > https://issues.apache.org/jira/browse/IGNITE-2680 > > -Val > > > > -- > View this message in context: http://apache-ignite-users. > 70518.x6.nabble.com/Limit-the-number-of-results-query-tp9002p9007.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. > --001a11474ba4f3c03605427e2fb3 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
HI Val,

thanks for response.
=
OOO is on server. Does server have separate memory blocks fo= r each query results ? how does that work when number of number of queries = executed in parallel ?=C2=A0

Thanks

On 16 November 2016 = at 02:31, vkulichenko <valentin.kulichenko@gmail.com> wrote:
Do you mean OOM on the serve= r or on the client? On server you indeed will
need some spare space for any ongoing operations (not only queries,
actually). You should make sure that this space is enough for you load. On<= br> client you should not get OOM because results are sent in pages (unless you=
call QueryCursor.getAll). If you iterate through the cursor, you will have<= br> only one page in client memory at a time which is 1024 rows by default.

Query cancellation and timeout will be available in 1.8:
https://issues.apache.org/jira/browse/IGNITE-2= 680

-Val



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.= com/Limit-the-number-of-results-query-tp9002p9007.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

--001a11474ba4f3c03605427e2fb3--