[Tarantool-patches] [PATCH 0/2] reduce performance degradation introduced by JSON path indices

[Serge Petrenko]

Issue: https://github.com/tarantool/tarantool/issues/4774

Branch: sp/gh-4774-multikey-refactoring


14.11.2020 20:28, Serge Petrenko пишет:
> The patchset fixes two degradations found by measuring snapshot recovery time
> for a 1.5G snapshot containing 30M tuples in a memtx space with a simple primary
> key and one secondary key over 4 integer and one string field.
>
> The first degradation manifests itself during snapshot recovery phase (the one
> with "3.5M rows processed" messages) and is connected to `memtx_tuple_new`
> slowdown due to unoptimised `tuple_field_map_create`.
>
> First patch deals with this degradation and manages to restore almost all
> performance lost since 1.10. (The patched version is only 11% slower than 1.10,
> while the current master is 39% slower on this phase).
>
> The second degradation appears during next snapshot recovery phase, secondary
> index building. Here the degradation is rooted in slow tuple field access via
> tuple_field_raw().
>
> The second patch deals with this issue and manages to restore part of the lost
> performance. (The patched version is 14% slower than 1.10 while the current
> master is 27% slower).
>
> Serge Petrenko (2):
>    box: speed up tuple_field_map_create
>    box: use tuple_field_raw_by_part where possible
>
>   src/box/tuple_compare.cc     | 37 ++++-----------
>   src/box/tuple_extract_key.cc | 10 +---
>   src/box/tuple_format.c       | 91 ++++++++++++++++++++++++++++++++++++
>   src/box/tuple_hash.cc        | 35 ++++----------
>   4 files changed, 111 insertions(+), 62 deletions(-)
>
-- 
Serge Petrenko