[infinispan-issues] [JBoss JIRA] (ISPN-5649) JDBC cache store upsert support

[Tristan Tarrant (JIRA)]

     [ https://issues.jboss.org/browse/ISPN-5649?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tristan Tarrant closed ISPN-5649.
---------------------------------
    Resolution: Duplicate Issue


> JDBC cache store upsert support
> -------------------------------
>
>                 Key: ISPN-5649
>                 URL: https://issues.jboss.org/browse/ISPN-5649
>             Project: Infinispan
>          Issue Type: Enhancement
>          Components: Loaders and Stores
>            Reporter: Gustavo Fernandes
>
> Currently before inserting an entry in the store, a SELECT is issued to find out if the entry already exists, and if so, it does an UPDATE instead of an INSERT.
> During data batch loading, those SELECT hurt performance and are not necessary, and even during normal regime, they could be promoted to upserts. The tricky part is, although upserts have been part of SQL standard since 2003, not all DBs support them in the same way [1][2]. So one way of tackling this is to enable support for standard SQL MERGE via configuration, falling back to SELECT+INSERT.
> [1] https://en.wikipedia.org/wiki/Merge_%28SQL%29#Other_non-standard_implementations
> [2] https://wiki.postgresql.org/wiki/UPSERT#UPSERT_as_implemented_in_practice



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)