Mailing-List: contact user-help@ignite.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ignite.apache.org
MIME-Version: 1.0
References: <364ba99b.a466.15fed580023.Coremail.wanxing987@163.com>
 <CAMP9FTRYEidmLBeQ1B7+a6KuHNfAzwf3AZscuym14tCwz-k38Q@mail.gmail.com>
 <2cea1adc.11bd.15ffcc9ac6b.Coremail.wanxing987@163.com> <5b546b72.8969.16006a7915e.Coremail.wanxing987@163.com>
 <CAMP9FTQPvy12BexQisUNVrkrcL_+Dum5nQwax1wj6ri_1HPiHA@mail.gmail.com> <4e71a2ba.7e17.1600c0c584d.Coremail.wanxing987@163.com>
In-Reply-To: <4e71a2ba.7e17.1600c0c584d.Coremail.wanxing987@163.com>
From: Denis Mekhanikov <dmekhanikov@gmail.com>
Date: Fri, 01 Dec 2017 12:30:54 +0000
Message-ID: <CAMP9FTRdoVDKajUBECC586QxAaS2HVu8OxkaHYN00bP9pxTRXg@mail.gmail.com>
Subject: Re: Re: Re:Poor performance select query with jdbc thin mode
To: user@ignite.apache.org
Content-Type: multipart/alternative; boundary="94eb2c06cb38d8c926055f468a52"
archived-at: Fri, 01 Dec 2017 12:31:10 -0000

--94eb2c06cb38d8c926055f468a52
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Lucky,

How much data do you retrieve in this query?
There is some overhead, caused by network communication, when you are using
JDBC drivers, but it's not expected to be so big.
Also do you connect over JDBC to the same node, on which you test
IgniteCache#query() ?

Denis

=D1=87=D1=82, 30 =D0=BD=D0=BE=D1=8F=D0=B1. 2017 =D0=B3. =D0=B2 11:30, Lucky=
 <wanxing987@163.com>:

> Denis,
>   It's worse!
>   There just have several sql  can be faster, the other took more time.
>   Thanks.
>
>
>
>
>
> =E5=9C=A8 2017-11-29 21:31:05=EF=BC=8C"Denis Mekhanikov" <dmekhanikov@gma=
il.com> =E5=86=99=E9=81=93=EF=BC=9A
>
> Lucky,
>
> Try enabling *enforceJoinOrder *parameter in JDBC connection string and
> let us know the result.
> Your JDBC connection string should look like this:
> jdbc:ignite:thin://127.0.0.1?*enforceJoinOrder=3Dtrue*
>
> Denis
>
>>
>>

--94eb2c06cb38d8c926055f468a52
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Lucky,</div><div><br></div>How much data do you retri=
eve in this query?<div>There is some overhead, caused by network communicat=
ion, when you are using JDBC drivers, but it&#39;s not expected to be so bi=
g.</div><div>Also do you connect over JDBC to the same node, on which you t=
est IgniteCache#query() ?</div><div><br></div><div>Denis</div></div><br><di=
v class=3D"gmail_quote"><div dir=3D"ltr">=D1=87=D1=82, 30 =D0=BD=D0=BE=D1=
=8F=D0=B1. 2017 =D0=B3. =D0=B2 11:30, Lucky &lt;<a href=3D"mailto:wanxing98=
7@163.com">wanxing987@163.com</a>&gt;:<br></div><blockquote class=3D"gmail_=
quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1=
ex"><div style=3D"line-height:1.7;color:#000000;font-size:14px;font-family:=
Arial"><div>Denis,</div><div>=C2=A0 It&#39;s worse!</div><div>=C2=A0 There =
just have several sql=C2=A0 can be faster, the other took more time.</div><=
div>=C2=A0 Thanks.</div></div><div style=3D"line-height:1.7;color:#000000;f=
ont-size:14px;font-family:Arial"><br><br><br><br><div style=3D"zoom:1"></di=
v><div id=3D"m_-5045849717447199576divNeteaseMailCard"></div><br>=E5=9C=A8 =
2017-11-29 21:31:05=EF=BC=8C&quot;Denis Mekhanikov&quot; &lt;<a href=3D"mai=
lto:dmekhanikov@gmail.com" target=3D"_blank">dmekhanikov@gmail.com</a>&gt; =
=E5=86=99=E9=81=93=EF=BC=9A<br> <blockquote id=3D"m_-5045849717447199576isR=
eplyContent" style=3D"PADDING-LEFT:1ex;MARGIN:0px 0px 0px 0.8ex;BORDER-LEFT=
:#ccc 1px solid"><div dir=3D"ltr">Lucky,<div><br></div><div>Try enabling=C2=
=A0<span style=3D"color:rgb(33,33,33)"><b>enforceJoinOrder </b>parameter in=
 JDBC connection string and let us know the result.</span></div><div><font =
color=3D"#212121">Your JDBC connection string should look like this:</font>=
=C2=A0</div><div>jdbc:ignite:thin://<a href=3D"http://127.0.0.1/" target=3D=
"_blank">127.0.0.1</a>?<b>enforceJoinOrder=3Dtrue</b></div><div><b><br></b>=
</div><div>Denis</div><div class=3D"gmail_quote"><blockquote class=3D"gmail=
_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:=
1ex"><div style=3D"line-height:1.7;color:#000000;font-size:14px;font-family=
:Arial"><blockquote id=3D"m_-5045849717447199576m_-6424350660893247620m_-82=
03913515952965779isReplyContent" style=3D"PADDING-LEFT:1ex;MARGIN:0px 0px 0=
px 0.8ex;BORDER-LEFT:#ccc 1px solid"><div style=3D"font-family:&quot;Helvet=
ica&quot;;font-size:14px;color:#31353b;line-height:1.5"><blockquote id=3D"m=
_-5045849717447199576m_-6424350660893247620m_-8203913515952965779ntes-pcmai=
l-quote" style=3D"margin:0;padding:0;font-size:14px;font-family:&#39;&#39;"=
><br>
</blockquote>
</div>

</blockquote></div></blockquote></div></div>
</blockquote></div></blockquote></div>

--94eb2c06cb38d8c926055f468a52--