[
https://issues.apache.org/jira/browse/IGNITE-10329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16695965#comment-16695965
]
Pavel Kuznetsov commented on IGNITE-10329:
------------------------------------------
[~vozerov] see mysql .properties file commited
(https://github.com/apache/ignite/pull/5479/files#diff-fca692296dbed27188a9e1653590784d).
See my sanity results (on my laptop).
Uploaded 1M (Person)+ 100K (Org) rows.
*Simple select 1K rows: *
||Vendor || Queries/sec, Avg||
| Ignite | 5.75 |
| MySQL | 15.47 |
| PostgreSQL | 32.02 |
*Select 1K rows + join : *
||Vendor || Queries/sec, Avg||
| Ignite | 5.76 |
| MySQL | 12.23 |
| PostgreSQL | 29.82 |
Ignite cluster : 1 srv + 1 client (thin driver) on the same host, syn mode
PRIMARY_SYNC, no backups. (todo : remove confusing option "-b" from script).
> 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)
