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