ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Denis Mekhanikov <dmekhani...@gmail.com>
Subject Re: Poor performance select query with jdbc thin mode
Date Fri, 24 Nov 2017 12:25:28 GMT
Hi!

Please try running the same test on Ignite 2.3
Also try changing to JDBC client driver
<https://apacheignite-sql.readme.io/docs/jdbc-client-driver> and let us
know the results.

Denis

пт, 24 нояб. 2017 г. в 12:25, Lucky <wanxing987@163.com>:

> Hi:
>    I need to return a ResultSet, So I had to use jdbc thin mode to execute
> select query.
>    But the performance is not acceptable!
>    The sql and explain is like this:
>      Two tables both have 1,500,000 rows and about 15 columns.
>      It took 3 seconds in single ignite  node ,and took 6 seconds in
> cluster(3 ignite nodes).
>      But if i execute the sql with cache.query(new SQLFieldsQuery(sql))
> ,it just took 400ms in single ignite node , and took 200ms in cluster(3
> ignite nodes).
>      Ignite version is 2.2.
>      What suggestions?
>      Thanks.
>
>
>
>

Mime
View raw message