ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Taras Ledkov (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (IGNITE-6217) Add benchmark to compare JDBC drivers and native SQL execution
Date Tue, 10 Oct 2017 09:51:00 GMT

    [ 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:50 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})
|




> 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)

Mime
View raw message