[
https://issues.apache.org/jira/browse/IGNITE-10329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16695944#comment-16695944
]
ASF GitHub Bot commented on IGNITE-10329:
-----------------------------------------
GitHub user pavel-kuznetsov opened a pull request:
https://github.com/apache/ignite/pull/5479
IGNITE-10329: query and query-join benchmarks for Ignite, Postgresql and
Mysql
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/gridgain/apache-ignite ignite-10329
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/ignite/pull/5479.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #5479
----
commit 6a1144bc95b45f7d048675442ac91839255ad167
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-11-20T18:33:14Z
ignite-10329: Draft of simple select benchmark.
commit 58b05e696323781f0696b6e814aab16eadf52fe5
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-11-20T19:40:41Z
ignite-10329: Draft for benchmarks.
Added 2 benchmarks that perform select and select with join operations.
Added configuration file only for Ignite.
commit 38647a095fe05f74792706827fc732057f773ad3
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-11-20T19:53:23Z
ignite-10329: fixed comment.
commit 7ca39c87a86969465c53b10f94530ec550473b80
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-11-20T20:00:48Z
ignite-10329: Fixed parameter in test().
commit 512a8c41f12768922d4cd02a1ca3794ea8b233de
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-11-20T20:06:34Z
ignite-10329: Fixed parameters in test().
commit ea93a3f61e7272e169ef7156a04fe985c4a841fd
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-11-21T09:17:07Z
ignite-10329: Fixed typo in the query.
Join benchmark have been fixed.
commit fdf62dfb159f105b06cef69461c6d36b5358d921
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-11-21T14:00:35Z
ignite-10329: Fixed queries for postgresql.
Changed LONG -> BIGINT, used PUBLIC schema explicitly.Added properties
file for postgresql run.
commit a1a9cb02166fa6aee84d1417225fb2bc02574c6d
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-11-22T11:25:04Z
ignite-10329: Added mysql configuration.
commit 14932ff449af4ddfcf0c28e327e8b48229974eba
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-11-22T14:17:25Z
ignite-10329: Made loading faster. Logging.
Added batching, disabled autocommit (made mysql loading super-fast) and
improved logging of database population process.
----
> 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)
