[infinispan-issues] [JBoss JIRA] Created: (ISPN-877) analyse, document and suggest indexing the JDBC cache store

[Mircea Markus (JIRA)]

analyse, document and suggest indexing the JDBC cache store
-----------------------------------------------------------

                 Key: ISPN-877
                 URL: https://issues.jboss.org/browse/ISPN-877
             Project: Infinispan
          Issue Type: Feature Request
          Components: Loaders and Stores
    Affects Versions: 4.2.0.Final
            Reporter: Mircea Markus
            Assignee: Mircea Markus
             Fix For: 5.0.0.ALPHA2


Adding indexes to the JDBC cache store's backend table can drastically increase performance especially for the JdbcStringBasedCacheStore and partially for the JdbcMixedCacheStore.
Investigate weather indexes can be defined through Jdbc in a portable manner (same way the tables are created on startup) or at least update documentation to describe how indexes should be defined and the advantages of having them defined.

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira