[ 
https://issues.apache.org/jira/browse/IGNITE-17325?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17950907#comment-17950907
 ] 

Vladislav Pyatkov commented on IGNITE-17325:
--------------------------------------------

Before
{noformat}
Benchmark                 (batch)  (fieldLength)  (fieldValueGeneration)  
(fsync)  (idxes)  (partitionCount)   Mode  Cnt       Score       Error  Units
UpsertKvBenchmark.upsert        1            100            uniquePrefix    
false        0                32  thrpt   20  152031.691 ± 15836.487  ops/s
UpsertKvBenchmark.upsert        1            100            uniquePrefix    
false       10                32  thrpt   20   23518.028 ±   636.437  ops/s
UpsertKvBenchmark.upsert        1            100           uniquePostfix    
false        0                32  thrpt   20  154772.141 ± 16071.561  ops/s
UpsertKvBenchmark.upsert        1            100           uniquePostfix    
false       10                32  thrpt   20   24372.917 ±   457.457  ops/s
{noformat}

After
{noformat}
Benchmark                 (batch)  (fieldLength)  (fieldValueGeneration)  
(fsync)  (idxes)  (partitionCount)   Mode  Cnt       Score       Error  Units
UpsertKvBenchmark.upsert        1            100            uniquePrefix    
false        0                32  thrpt   20  150744.090 ± 16891.659  ops/s
UpsertKvBenchmark.upsert        1            100            uniquePrefix    
false       10                32  thrpt   20   47811.541 ±  1826.931  ops/s
UpsertKvBenchmark.upsert        1            100           uniquePostfix    
false        0                32  thrpt   20  161325.954 ± 13329.982  ops/s
UpsertKvBenchmark.upsert        1            100           uniquePostfix    
false       10                32  thrpt   20   21747.674 ±   807.172  ops/s
{noformat}
The indexes in the case where the value uniqueness might be determined by first 
bytes become twice as fast (47811 vs 23518 ops/s).

> Implement a comparator for inlined BinaryTuple in sorted index
> --------------------------------------------------------------
>
>                 Key: IGNITE-17325
>                 URL: https://issues.apache.org/jira/browse/IGNITE-17325
>             Project: Ignite
>          Issue Type: Improvement
>            Reporter: Ivan Bessonov
>            Assignee: Vladislav Pyatkov
>            Priority: Major
>              Labels: ignite-3
>             Fix For: 3.1
>
>          Time Spent: 3h 40m
>  Remaining Estimate: 0h
>
> We need to implement an inlined *BinaryTuple* comparator in a sorted index 
> for a B+tree.
> You need to take into account the format of the *BinaryTuple* and the fact 
> that it can be truncated.
> As a basis, you can take 
> *org.apache.ignite.internal.storage.index.BinaryTupleComparator*.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to