[infinispan-issues] [JBoss JIRA] (ISPN-6710) TableManager when creating a table should also add index for expiration column

Vladimir Blagojevic (JIRA) issues at jboss.org
Sat Jul 9 05:18:08 EDT 2016


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

Vladimir Blagojevic updated ISPN-6710:
--------------------------------------
    Fix Version/s: 9.0.0.Alpha4
                       (was: 9.0.0.Alpha3)


> TableManager when creating a table should also add index for expiration column
> ------------------------------------------------------------------------------
>
>                 Key: ISPN-6710
>                 URL: https://issues.jboss.org/browse/ISPN-6710
>             Project: Infinispan
>          Issue Type: Enhancement
>          Components: Loaders and Stores
>            Reporter: William Burns
>            Assignee: Ryan Emerson
>             Fix For: 9.0.0.Alpha4
>
>
> All stores are required to have purging enabled now.  This can cause performance issues with stores like Jdbc*Store since it may cause a full table scan without an index.  We should make sure these tables have an index on this field to prevent possible performance issues.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)


More information about the infinispan-issues mailing list