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 7995C200D53 for ; Tue, 5 Dec 2017 11:02:29 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 78099160C1B; Tue, 5 Dec 2017 10:02:29 +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 BE3EF160C0A for ; Tue, 5 Dec 2017 11:02:28 +0100 (CET) Received: (qmail 7967 invoked by uid 500); 5 Dec 2017 10:02:27 -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 7957 invoked by uid 99); 5 Dec 2017 10:02:27 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Dec 2017 10:02:27 +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 F0B44C408B for ; Tue, 5 Dec 2017 10:02:26 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.879 X-Spam-Level: * X-Spam-Status: No, score=1.879 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_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-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-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id lGNqmSoyZUrh for ; Tue, 5 Dec 2017 10:02:21 +0000 (UTC) Received: from mail-it0-f47.google.com (mail-it0-f47.google.com [209.85.214.47]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 4C8695F2A8 for ; Tue, 5 Dec 2017 10:02:21 +0000 (UTC) Received: by mail-it0-f47.google.com with SMTP id u62so197477ita.2 for ; Tue, 05 Dec 2017 02:02:21 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=VVtlKU4NYPs6qPh/ajAmY88z+4ZOOfdr1bWVn1ffkWc=; b=aVLXauzWeBpxXy67awZF31zqHmYx2PD92zT6+in6KVmHaC/EKFkR0ce8cNVf+T+Hfa W8IezANxP3cAn+H6G7PnNkRimfTDsuiBDQW0dzDJHTX1fJx9tGSfXjVv0z5avA9WYPw7 HjkEM0ZN9vkSoi+DTkhaIeB8NdYqfAu9vbZF/xrOsD+cIF2FSeBA65JTrasjvZsKo/b8 /n7hOZkNrVEetawGs+FlDsSl6TyJZY2MttaUZAges1RTQ2Pt3JmKOQVREQGsSbbrCU5m zqtAOSPHB/3ioojMex79xZYa5D6yx76FFcbiIbX35suIjzfL0FEmzbd1Ro1Yw8ED9iMG 8Rgg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=VVtlKU4NYPs6qPh/ajAmY88z+4ZOOfdr1bWVn1ffkWc=; b=CjyFaqhfCe0r/iYj6F1PmP4MCnKIBVI7+7i84R3w7lZiUX9SjmMqX5R8gDi8GQ7b3a DNS/KFzom0jVPS7gqikbxjztQ1OsEwbqoFWeuDiGO7rXymydRdsDXMGRdeghz+evLJa8 CJ1yg9M0RItVsUMRwFrDUw7Ba/iFWz/D8/IMMdJkAiGFpWus/8RDOJpnXLkoUavHH9t5 XZxDdgaBPe2QsCMAjHGRUkDmhdBGJnmLLHQHEmaNXcXJfJXQSxmsnY8nAlnt9ed+yrTZ xHozQtpaliW8qqF8dgLIYe201LBN8Gs9bLA/EaK6pDQiun5ZJq9ZIIyCkH45b6fAxPZo tX1A== X-Gm-Message-State: AJaThX6Q9WE80gA96o4p0Dkofu0HcPAcgShJuIax1WtsClqs8rsrazZ2 ZryTbHu+3VMiEFCZqkYR9MpNWuL9e2ZvL1ls+O8= X-Google-Smtp-Source: AGs4zMazhSWNO4AKhP24rNGKTJiF/UnBxHt6a0weCqVqkPW+QN8/BOKKVXQQfNOawjlK/pvYt7+9Ef4CzYdQwPWrjqk= X-Received: by 10.36.84.72 with SMTP id t69mr17670374ita.74.1512468139785; Tue, 05 Dec 2017 02:02:19 -0800 (PST) MIME-Version: 1.0 References: <364ba99b.a466.15fed580023.Coremail.wanxing987@163.com> <2cea1adc.11bd.15ffcc9ac6b.Coremail.wanxing987@163.com> <5b546b72.8969.16006a7915e.Coremail.wanxing987@163.com> <4e71a2ba.7e17.1600c0c584d.Coremail.wanxing987@163.com> <29a2e687.b58b.160260ba4ba.Coremail.wanxing987@163.com> In-Reply-To: <29a2e687.b58b.160260ba4ba.Coremail.wanxing987@163.com> From: Denis Mekhanikov Date: Tue, 05 Dec 2017 10:02:09 +0000 Message-ID: Subject: Re: Re: Re: Re: Re: Re:Poor performance select query with jdbc thin mode To: user@ignite.apache.org Content-Type: multipart/alternative; boundary="001a1143b79834c119055f94eed8" archived-at: Tue, 05 Dec 2017 10:02:29 -0000 --001a1143b79834c119055f94eed8 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable So, the problem was in measurement, right? Denis =D0=B2=D1=82, 5 =D0=B4=D0=B5=D0=BA. 2017 =D0=B3. =D0=B2 12:39, Lucky : > > now it is about the same as JDBC thin mode. > > > > > > At 2017-12-05 16:52:48, "Denis Mekhanikov" wrote: > > Lucky, > > Thanks for the code. > And what is the time for cache.query() for the same query? > > Denis > > --001a1143b79834c119055f94eed8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
So, the problem was in measurement, right?

<= div>Denis

=D0=B2= =D1=82, 5 =D0=B4=D0=B5=D0=BA. 2017 =D0=B3. =D0=B2 12:39, Lucky <wanxing987@163.com>:

now it is about the same as JDBC thin mode.<= /div>





At 2017-12-05 16:52:48, "Denis= Mekhanikov" <dmekhanikov@gmail.com> wrote:
Lucky,

Thanks for the code.
And w= hat is the time for cache.query() for the same query?

<= div>Denis
--001a1143b79834c119055f94eed8--