[ https://issues.apache.org/jira/browse/IGNITE-6217?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16205619#comment-16205619 ]
Taras Ledkov edited comment on IGNITE-6217 at 10/16/17 9:46 AM: ---------------------------------------------------------------- The other benchmark result. Configurations: # Native SQL: 1 server, 1 client. SQL queries are execute4d on client on separate host # JDBCv2: 2 1 server, queries are executed on JDBC v2 client on separate host. # JDBC thin: 1 server, 1 client, JDBC thin client runs on separate host and connects to the client node. SQL queries are executed on JDBC client on separate4 host. SQL query: {{SELECT val FROM test WHERE id = <random (0..1M)>}} where TEST table contains two column {{id long, val long}} The table contains unique 1M rows. || Benchmark || Ops /sec || | Nativa SQL | 9385.99 | | JDBC v2 | 8888.48 | | JDBC thin | 4367.87 | was (Author: tledkov-gridgain): The other benchmark result. Configurations: # Native SQL: 1 server, 1 client. SQL queries are execute4d on client on separate host # JDBCv2: 2 1 server, queries are executed on JDBC v2 client on separate host. # JDBC thin: 1 server, 1 client, JDBC thin client runs on separate host and connects to the client node. SQL queries are executed on JDBC client on separate4 host. SQL query: {{SELECT val FROM test WHERE id = <random (0..1M)> }} where TEST table contains two column {{id long, val long}} The table contains unique 1M rows. || Benchmark || Ops /sec || | Nativa SQL | 9385.99 | | JDBC v2 | 8888.48 | | JDBC thin | 4367.87 | > Add benchmark to compare JDBC drivers and native SQL execution > -------------------------------------------------------------- > > Key: IGNITE-6217 > URL: https://issues.apache.org/jira/browse/IGNITE-6217 > Project: Ignite > Issue Type: Task > Components: jdbc, sql, yardstick > Affects Versions: 2.1 > Reporter: Taras Ledkov > Assignee: Taras Ledkov > Fix For: 2.4 > > > We have to compare performance of the native SQL execution (via Ignite SQL > API), JDBC v2 driver, that uses Ignite client to connect to grid and JDBC > thin client. -- This message was sent by Atlassian JIRA (v6.4.14#64029)