[
https://issues.apache.org/jira/browse/IGNITE-10329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16701824#comment-16701824
]
Pavel Kuznetsov commented on IGNITE-10329:
------------------------------------------
Added new seelect by PK benchmark : {{SELECT id FROM PUBLIC.PERSON WHERE id
BETWEEN ? AND ?}}
*Ignite:*
||Benchmark ||Configuration ||Queries/sec, avg||
|SimpleSelectBenchmark |select-simple-jdbc-thin-inmemory |816.77|
|SelectWithJoinBenchmark |select-join-jdbc-thin-inmemory |272.61|
|SelectByPkBenchmark |select-pk-jdbc-thin-inmemory |433.11|
|SimpleSelectBenchmark |select-simple-jdbc-thin-persistence |377.92|
|SelectWithJoinBenchmark |select-join-jdbc-thin-persistence |142.39|
|SelectByPkBenchmark |select-pk-jdbc-thin-persistence |390.17|
|SimpleSelectBenchmark |select-simple-jdbc-v2-inmemory |621.42|
|SelectWithJoinBenchmark |select-join-jdbc-v2-inmemory |203.33|
|SelectByPkBenchmark |select-pk-jdbc-v2-inmemory |694.39|
|SimpleSelectBenchmark |select-simple-jdbc-v2-persistence |480.91|
|SelectWithJoinBenchmark |select-join-jdbc-v2-persistence |173.72|
|SelectByPkBenchmark |select-pk-jdbc-v2-persistence |516.76|
> Create JDBC "query" and "query join" benchmarks and compare them with
> Postgres and MySQL
> ----------------------------------------------------------------------------------------
>
> Key: IGNITE-10329
> URL: https://issues.apache.org/jira/browse/IGNITE-10329
> Project: Ignite
> Issue Type: Task
> Components: sql, yardstick
> Reporter: Vladimir Ozerov
> Assignee: Pavel Kuznetsov
> Priority: Major
> Fix For: 2.8
>
>
> Currently we have {{IgniteSqlQueryBenchmark}} and
> {{IgniteSqlQueryJoinBenchmark}} benchmarks which query data over salary range
> and optionally joins it with second table. Let's create a set of similar
> benchmarks which will use JDBC to load and query data, and execute them
> against one-node Ignite cluster, MySQL and Postgres.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
