[
https://issues.apache.org/jira/browse/IGNITE-6217?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16148745#comment-16148745
]
Taras Ledkov edited comment on IGNITE-6217 at 10/10/17 9:51 AM:
----------------------------------------------------------------
{{benchmark-jdbc-sql.properties}} yardstick configuration is created.
Benchmark results (4 servers, 1 client):
|| Benchmark || Ops/sec (1 row in results) || Ops/sec (1000 rows in results) ||
| *NativeSQL* | 97983.90 | 4522.63 |
| *JDBC v2* | 76926.95 ({color:#d04437}-21%{color}) | 3706.86
({color:#d04437}-18%{color}) |
| *JDBC thin* | 38264.54 ({color:#d04437}-61%){color} | 2753.05
({color:#d04437}-25%{color}) |
----
Benchmark results (4 servers, 8 client):
|| Benchmark || Ops/sec (1 row in results) || Ops/sec (1000 rows in results) ||
| *NativeSQL* | 15841.80 | 1842.78 |
| *JDBC v2* | 14209.00 ({color:#d04437}-10%{color}) | 1247.67
({color:#d04437}-32%{color}) |
| *JDBC thin* | 5130.02 ({color:#d04437}-68%){color} | 332.39
({color:#d04437}-82%{color}) |
was (Author: tledkov-gridgain):
{{benchmark-jdbc-sql.properties}} yardstick configuration is created.
Benchmark results (4 servers, 1 client):
|| Benchmark || Ops/sec (1 row in results) || Ops/sec (1000 rows in results) ||
| *NativeSQL* | 97983.90 | 4522.63 |
| *JDBC v2* | 76926.95 ({color:#d04437}-21%{color}) | 3706.86
({color:#d04437}-18%{color}) |
| *JDBC thin* | 38264.54 ({color:#d04437}-61%){color} | 2753.05
({color:#d04437}-25%{color}) |
Benchmark results (4 servers, 8 client):
|| Benchmark || Ops/sec (1 row in results) || Ops/sec (1000 rows in results) ||
| *NativeSQL* | 15841.80 | 1842.78 |
| *JDBC v2* | 14209.00 ({color:#d04437}-10%{color}) | 1247.67
({color:#d04437}-32%{color}) |
| *JDBC thin* | 5130.02 ({color:#d04437}-68%){color} | 332.39
({color:#d04437}-82%{color}) |
> 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)
