[
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/17/17 9:55 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 columns: {{id long, val long}}
The table contains 1M unique rows.
|| Benchmark || Ops /sec (1 row) || Ops/sec (1000 rows) || Ops / sec (10000
rows) || Ops / sec (1M rows) ||
| Nativa SQL | 9385.99 | 903.53 | 106.77 | 0.931 |
| JDBC v2 | 8888.48 | 782.23 | 105.27| 0.919 |
| JDBC thin | 4367.87 | 673.16 | 94.90 | 0.886 |
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 columns: {{id long, val long}}
The table contains 1M unique rows.
|| Benchmark || Ops /sec (1 row) ||
| 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)
