[
https://issues.apache.org/jira/browse/IGNITE-21275?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ivan Artiukhov updated IGNITE-21275:
------------------------------------
Attachment: 1241-jdbc-insert.png
> Up to 5x difference in performance between SQL API and key-value API
> --------------------------------------------------------------------
>
> Key: IGNITE-21275
> URL: https://issues.apache.org/jira/browse/IGNITE-21275
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Ivan Artiukhov
> Priority: Major
> Labels: ignite-3
> Attachments: 1240-sql-insert.png, 1240-sql-select.png,
> 1241-jdbc-insert.png, 1242-kv-get.png, 1242-kv-put.png
>
>
> AI3 rev. ca21384f85e8c779258cb3b21f54b6c30a7071e4 (Jan 16 2024)
> Compare two benchmark runs:
> * a benchmark which uses KeyValueView to perform single {{put()}} and
> {{{}get(){}}}:
> [https://github.com/gridgain/YCSB/blob/ycsb-2023.11/ignite3/src/main/java/site/ycsb/db/ignite3/IgniteClient.java]
>
> * a benchmark which performs {{INSERT}} and {{SELECT}} via {{Statement}}
> objects by using Ignite SQL API:
> [https://github.com/gridgain/YCSB/blob/ycsb-2023.11/ignite3/src/main/java/site/ycsb/db/ignite3/IgniteSqlClient.java]
>
> h1. Run 1, PUT/INSERT
> Insert N unique entries into a single-node cluster from a single-threaded
> client.
> h2. KeyValueView
> N = 250000
> {code:java}
> Command line: -db site.ycsb.db.ignite3.IgniteClient -load -P
> /opt/pubagent/poc/config/ycsb/workloads/workloadc -threads 1 -p
> recordcount=250000 -p warmupops=50000 -p dataintegrity=true -p
> measurementtype=timeseries -p status.interval=1 -p hosts=192.168.1.37 -s
> {code}
> !1242-kv-put.png!
> h2. SQL API
> N = 15000
>
> {code:java}
> Command line: -db site.ycsb.db.ignite3.IgniteSqlClient -load -P
> /opt/pubagent/poc/config/ycsb/workloads/workloadc -threads 1 -p
> recordcount=150000 -p warmupops=15000 -p dataintegrity=true -p
> measurementtype=timeseries -p status.interval=1 -p hosts=192.168.1.47 -s
> {code}
> !1240-sql-insert.png!
>
> h1. Run 2, GET/SELECT
> Get N entries inserted on Run 1.
> h2. KeyValueView
> N = 250000
>
> {code:java}
> Command line: -db site.ycsb.db.ignite3.IgniteClient -t -P
> /opt/pubagent/poc/config/ycsb/workloads/workloadc -threads 1 -p
> operationcount=250000 -p recordcount=250000 -p warmupops=50000 -p
> dataintegrity=true -p measurementtype=timeseries -p status.interval=1 -p
> hosts=192.168.1.37 -s{code}
> !1242-kv-get.png!
>
> h2. SQL API
> N = 150000
> {code:java}
> Command line: -db site.ycsb.db.ignite3.IgniteSqlClient -t -P
> /opt/pubagent/poc/config/ycsb/workloads/workloadc -threads 1 -p
> operationcount=150000 -p recordcount=150000 -p warmupops=15000 -p
> dataintegrity=true -p measurementtype=timeseries -p status.interval=1 -p
> hosts=192.168.1.47 -s {code}
> !1240-sql-select.png!
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
