[jira] [Created] (IGNITE-7531) SQL: Create data load benchmarks

["Vladimir Ozerov (JIRA)" <ji...@apache.org>]

Vladimir Ozerov created IGNITE-7531:
---------------------------------------

             Summary: SQL: Create data load benchmarks
                 Key: IGNITE-7531
                 URL: https://issues.apache.org/jira/browse/IGNITE-7531
             Project: Ignite
          Issue Type: Task
          Components: sql, yardstick
            Reporter: Vladimir Ozerov
            Assignee: Pavel Kuznetsov
             Fix For: 2.5


We need to implement a set of data loading benchmarks to better understand how fast Ignite is able to consume data. This task consists of two steps:
1) Extend Yardstick capabilities
2) Create set of benchmarks

1) Yardstick
Data load benchmark should be executed in single-shot mode: only one iteration, only total execution time is needed, start callback for setup and warmup, stop callback for cleanup. 
Currently Yardstick cannot do that, so we need to extend it. Possibly, we can control this through new {{boolean BenchmarkDriver.isSingleShot()}} method.

2) Benchmarks 
At first let's focus on thin JDBC driver. The following cases should be executed:
2.1) Normal INSERT
2.2) Batched INSERT
2.3) Streaming INSERT (when IGNITE-7253 is ready)
2.4) P. 1-3 with and without dynamically disabled WAL (ALTER TABLE ... NOLOGGING)
2.5) P. 1-3 with additional indexes - either created before data load on empty table, or after load on table with data.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)