Return-Path: X-Original-To: apmail-ignite-user-archive@minotaur.apache.org Delivered-To: apmail-ignite-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9531418C84 for ; Mon, 17 Aug 2015 20:34:09 +0000 (UTC) Received: (qmail 45654 invoked by uid 500); 17 Aug 2015 20:34:09 -0000 Delivered-To: apmail-ignite-user-archive@ignite.apache.org Received: (qmail 45612 invoked by uid 500); 17 Aug 2015 20:34:09 -0000 Mailing-List: contact user-help@ignite.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ignite.incubator.apache.org Delivered-To: mailing list user@ignite.incubator.apache.org Received: (qmail 45602 invoked by uid 99); 17 Aug 2015 20:34:09 -0000 Received: from Unknown (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Aug 2015 20:34:09 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 159281AA3A4 for ; Mon, 17 Aug 2015 20:34:09 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.202 X-Spam-Level: * X-Spam-Status: No, score=1.202 tagged_above=-999 required=6.31 tests=[DKIM_ADSP_CUSTOM_MED=0.001, NML_ADSP_CUSTOM_MED=1.2, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-us-west.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id d6ds2q9qz1eb for ; Mon, 17 Aug 2015 20:33:57 +0000 (UTC) Received: from mbob.nabble.com (mbob.nabble.com [162.253.133.15]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTP id 68010210C9 for ; Mon, 17 Aug 2015 20:33:57 +0000 (UTC) Received: from malf.nabble.com (unknown [162.253.133.59]) by mbob.nabble.com (Postfix) with ESMTP id F246B1363544 for ; Mon, 17 Aug 2015 13:32:38 -0700 (PDT) Date: Mon, 17 Aug 2015 13:28:11 -0700 (PDT) From: javadevmtl To: user@ignite.incubator.apache.org Message-ID: <1439843291263-1014.post@n6.nabble.com> In-Reply-To: References: <1439839891847-1010.post@n6.nabble.com> Subject: Re: Query performance MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, thanks 2 nodes as indicated in the original thread. I'm pretty sure I have @QuerySqlField(index = true) But I would still expect a specific constant response time up to a certain amount of records instead of off the start line the query time degrades from 0-30K records there something going on... I need to do count(distinct someField) where another field = ? It's doable using put/get but then I would need to keep track of individual keys for each count I want to do. So for a single entry I need 18 different keys to track unique counts for each property. Now if we can do analytics style queries using indexes in real time that would be huge! Especially in the couple milliseconds! -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Re-Query-performance-tp1009p1014.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.