Return-Path: X-Original-To: apmail-ignite-dev-archive@minotaur.apache.org Delivered-To: apmail-ignite-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D8E6717278 for ; Thu, 5 Nov 2015 06:48:26 +0000 (UTC) Received: (qmail 6838 invoked by uid 500); 5 Nov 2015 06:48:26 -0000 Delivered-To: apmail-ignite-dev-archive@ignite.apache.org Received: (qmail 6793 invoked by uid 500); 5 Nov 2015 06:48:26 -0000 Mailing-List: contact dev-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ignite.apache.org Delivered-To: mailing list dev@ignite.apache.org Received: (qmail 6781 invoked by uid 99); 5 Nov 2015 06:48:26 -0000 Received: from Unknown (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Nov 2015 06:48:26 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 17526C1DC4 for ; Thu, 5 Nov 2015 06:48:26 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.88 X-Spam-Level: ** X-Spam-Status: No, score=2.88 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id EXkgkXikSiNe for ; Thu, 5 Nov 2015 06:48:19 +0000 (UTC) Received: from mail-yk0-f169.google.com (mail-yk0-f169.google.com [209.85.160.169]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTPS id 0B96B20A92 for ; Thu, 5 Nov 2015 06:48:19 +0000 (UTC) Received: by ykdv3 with SMTP id v3so25588209ykd.0 for ; Wed, 04 Nov 2015 22:48:18 -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 :content-type; bh=1wUqRQ9/PtDmBO7FsfdteSy+Ug3bE25LPicmXa+Kn0U=; b=In10kNtrP6dE7AGhM/qXSp2B3yK/HV9ouUgeesifayYlPtjt+JDT5b6jMQ542h6DE1 DrOlDMtk59SERFZ9BzCl+1dSL7nH+QUs2YqXbpUhopZtATnCbxV6uH8FLH+Iuc7SuHri PQHxlFbW8nrd6/RIDM/T96GariNoNeo0jb15dBRoVw99iHzd2RDN3j7pIxfFavaC8cOa co1Ui7WCQDdbIfCk4Lofan5P6GMVR3XLmWRwRtDFyV91q0lpzBJbZ1IQxE3PyZP29Deo 7dTVc1kplJ+oXDlWIeUAlah78YLnMCWKT7sWHoeZ33NI5AoUlYt1pOPwniepHfRhtkon Gm9w== X-Received: by 10.31.182.208 with SMTP id g199mr5655226vkf.21.1446706097802; Wed, 04 Nov 2015 22:48:17 -0800 (PST) MIME-Version: 1.0 Received: by 10.103.21.194 with HTTP; Wed, 4 Nov 2015 22:47:38 -0800 (PST) In-Reply-To: References: From: Sergi Vladykin Date: Thu, 5 Nov 2015 09:47:38 +0300 Message-ID: Subject: Re: Prepared statement concept in indexing To: dev@ignite.apache.org Content-Type: multipart/alternative; boundary=001a114381a60dd5310523c5835c --001a114381a60dd5310523c5835c Content-Type: text/plain; charset=UTF-8 Ok, I've created jira issue and will try to put this into 1.5. release. https://issues.apache.org/jira/browse/IGNITE-1856 Sergi 2015-11-04 21:17 GMT+03:00 Vladimir Ozerov : > Agree, it would be cool if we cache parsed queries without any changes to > public API. > > But Dima, note that I saw this "20%" on local benchmark with only 1 node. I > expect that in distributed environment it will be amortized by network. > > On Wed, Nov 4, 2015 at 6:00 PM, Sergi Vladykin > wrote: > > > Yes, it is a problem and I believe after distributed joins feature will > be > > merged, it will become even worse. > > > > Though I'd prefer to avoid changing public API for now. I believe it must > > be enough to cache > > and reuse parsed query information, generated queries and other stuff. > > > > Sergi > > > > 2015-11-04 16:43 GMT+03:00 Vladimir Ozerov : > > > > > Igniters, > > > > > > Currently I'm profiling query execution on a single node on a > realtively > > > small data set (100K entries). What I see is that query parsing > consumes > > > about 20% of all execution time. > > > > > > Do we have something like JDBC PreparedStatement for our queries to > > > minimize this overhead? If no, does it make sense to have it? > > > > > > Vladimir. > > > > > > --001a114381a60dd5310523c5835c--