[
https://issues.apache.org/jira/browse/IGNITE-20882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17800470#comment-17800470
]
Andrey Novikov commented on IGNITE-20882:
-----------------------------------------
Single-node embedded:
||Benchmark||Score(us/op)||
|CriteriaSingleNodeBenchmark.criteriaGet|1780,171 ± 35,306|
|CriteriaSingleNodeBenchmark.kvGet|121,114 ± 1,726|
|CriteriaSingleNodeBenchmark.sqlGet|1703,928 ± 34,945|
> Append performance tests
> ------------------------
>
> Key: IGNITE-20882
> URL: https://issues.apache.org/jira/browse/IGNITE-20882
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Andrey Novikov
> Assignee: Andrey Novikov
> Priority: Major
> Labels: ignite-3
>
> # Compare single-key criteria vs single-key SQL vs table.get(PK)
> * Expect to have similar performance
> * Check single-node embedded, distributed with no partition awareness,
> distributed with partition awareness
> * NOTE: future improvement for criteria query – lookup affinity node if PK
> or colocation key is in the criteria.
> # Compare criteria vs SQL when affinity key is specified (unicast when
> partition pruning is added)
> # Compare criteria vs SQL for broadcast queries – latency and throughput
> # Compare criteria vs SQL – time it takes to iterate over 10kk entries
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
