[infinispan-issues] [JBoss JIRA] Created: (ISPN-686) JdbcStringBasedCacheStore loads previous data from store before an insert

[Sanne Grinovero (JIRA)]

JdbcStringBasedCacheStore loads previous data from store before an insert
-------------------------------------------------------------------------

                 Key: ISPN-686
                 URL: https://jira.jboss.org/browse/ISPN-686
             Project: Infinispan
          Issue Type: Bug
          Components: Loaders and Stores
    Affects Versions: 4.2.0.ALPHA2, 4.1.0.Final, 4.0.0.Final
            Reporter: Sanne Grinovero
            Assignee: Manik Surtani
             Fix For: 4.2.0.Final, 5.0.0.Final


The JdbcStringBasedCacheStore implementation loads the previous data on an insert to find out if it should generate an UPDATE or INSERT statement, while it would perform much better to just verify if the primary key exists.

On top of this, some databases provide ways to avoid the need to check at all, like MySQL's " INSERT ... ON DUPLICATE KEY UPDATE"
[http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html]

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira