ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Denis Mekhanikov <dmekhani...@gmail.com>
Subject Re: Re: Re:Poor performance select query with jdbc thin mode
Date Fri, 01 Dec 2017 12:30:54 GMT
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

чт, 30 нояб. 2017 г. в 11:30, Lucky <wanxing987@163.com>:

> Denis,
>   It's worse!
>   There just have several sql  can be faster, the other took more time.
>   Thanks.
>
>
>
>
>
> 在 2017-11-29 21:31:05,"Denis Mekhanikov" <dmekhanikov@gmail.com> 写道:
>
> 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=true*
>
> Denis
>
>>
>>

Mime
View raw message