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 Mon, 16 Oct 2017 09:47:00 GMT

    [ 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 columns: {{id long, val long}}
The table contains 1M unique 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 columns: {{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)

Mime
View raw message