You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Andrey Novikov (Jira)" <ji...@apache.org> on 2024/02/12 10:35:00 UTC
[jira] [Comment Edited] (IGNITE-20882) Append performance tests
[ https://issues.apache.org/jira/browse/IGNITE-20882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17800470#comment-17800470 ]
Andrey Novikov edited comment on IGNITE-20882 at 2/12/24 10:34 AM:
-------------------------------------------------------------------
Single-node embedded (CriteriaEmbeddedNodeBenchmark):
||Benchmark||Score(us/op)||
|criteriaGet|114,135 ± 1,129|
|kvGet|72,062 ± 0,309|
|sqlGet|105,260 ± 0,521|
Two nodes, thin client(CriteriaThinClientBenchmark):
||Benchmark||Score(us/op)||
|criteriaGet|1780,171 ± 35,306|
|kvGet|251,105 ± 8,618|
|sqlGet|2694,740 ± 72,396|
|criteriaGetNonNullTxDisablesPartitionAwareness|2935,503 ± 192,479|
|kvGetNonNullTxDisablesPartitionAwareness|352,037 ± 7,819|
|sqlGetNonNullTxDisablesPartitionAwareness|2814,066 ± 88,770|
|sqlIterate|1603991,380 ± 12153,762|
|criteriaIterate|1501173,640 ± 31600,562|
was (Author: anovikov):
Single-node embedded (CriteriaSingleNodeBenchmark):
||Benchmark||Score(us/op)||
|criteriaGet|1780,171 ± 35,306|
|kvGet|121,114 ± 1,726|
|sqlGet|1703,928 ± 34,945|
Two nodes, thin client(CriteriaThinClientBenchmark):
||Benchmark||Score(us/op)||
|criteriaGet|1780,171 ± 35,306|
|kvGet|251,105 ± 8,618|
|sqlGet|2694,740 ± 72,396|
|criteriaGetNonNullTxDisablesPartitionAwareness|2935,503 ± 192,479|
|kvGetNonNullTxDisablesPartitionAwareness|352,037 ± 7,819|
|sqlGetNonNullTxDisablesPartitionAwareness|2814,066 ± 88,770|
|sqlIterate|1603991,380 ± 12153,762|
|criteriaIterate|1501173,640 ± 31600,562|
> 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
> Fix For: 3.0.0-beta2
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> # 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)