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 <[email protected]>: > 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. > > > >
