[
https://issues.apache.org/jira/browse/IGNITE-26452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nikita Amelchev reassigned IGNITE-26452:
----------------------------------------
Assignee: Nikita Amelchev
> SQL Calcite: INSERT operations in External Storage mode trigger
> CacheStore#load invocation
> ------------------------------------------------------------------------------------------
>
> Key: IGNITE-26452
> URL: https://issues.apache.org/jira/browse/IGNITE-26452
> Project: Ignite
> Issue Type: Bug
> Affects Versions: 2.17
> Reporter: Andrei Nadyktov
> Assignee: Nikita Amelchev
> Priority: Minor
> Labels: ise
> Attachments: CacheStoreLoadTests.patch
>
>
> It seems that we have an unnecessary {{CacheStore#load}} invocation when
> executing INSERT statements in Ignite.
> *Prerequisites:*
> # Ignite used as a caching layer to an existing database.
> # Write-Through, Read-Through are enabled.
> # Custom implementation of CacheStore is used.
> # Calcite engine is used.
> When inserting some rows into table, we expect that only {{CacheStore#write}}
> method will be invoked for writing data to an external database. What
> actually happens is that, for some unknown reasons, {{CacheStore#load}} is
> called before {{{}CacheStore#write{}}}. This may slow down overall
> performance due to redundant read operation from the external database.
> It seems that such behaviour is only reproduced when Calcite engine is
> enabled. This happens even with {{CacheConfiguration#setLoadPreviousValue}}
> flag set to false.
> *Reproducer:* [^CacheStoreLoadTests.patch]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
