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 4E76A184D6 for ; Fri, 26 Feb 2016 19:08:46 +0000 (UTC) Received: (qmail 75142 invoked by uid 500); 26 Feb 2016 19:08:44 -0000 Delivered-To: apmail-ignite-user-archive@ignite.apache.org Received: (qmail 75049 invoked by uid 500); 26 Feb 2016 19:08:44 -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 74917 invoked by uid 99); 26 Feb 2016 19:08:44 -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; Fri, 26 Feb 2016 19:08:44 +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 B7FEAC093B for ; Fri, 26 Feb 2016 19:08:43 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.173 X-Spam-Level: ** X-Spam-Status: No, score=2.173 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] autolearn=disabled Received: from mx2-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 s-B3lyD8S8AF for ; Fri, 26 Feb 2016 19:08:43 +0000 (UTC) Received: from mbob.nabble.com (mbob.nabble.com [162.253.133.15]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTP id 6CB035F119 for ; Fri, 26 Feb 2016 19:08:42 +0000 (UTC) Received: from malf.nabble.com (unknown [162.253.133.59]) by mbob.nabble.com (Postfix) with ESMTP id 297E421A5872 for ; Fri, 26 Feb 2016 11:01:02 -0800 (PST) Date: Fri, 26 Feb 2016 10:56:27 -0800 (PST) From: vkulichenko To: user@ignite.apache.org Message-ID: <1456512987756-3206.post@n6.nabble.com> In-Reply-To: References: Subject: Re: SQL query performance MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi Shaomin, Before starting to provide best performance, JVM needs some time to warm up and apply all JIT optimizations. It sounds like you're running the query only once, so this doesn't happen. Do this several times in a loop and you should get 0ms timings. -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQL-query-performance-tp3202p3206.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.