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

[Ryan Emerson (JIRA)]

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

Ryan Emerson updated ISPN-6710:
-------------------------------
    Status: Open  (was: New)


> 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.Beta1
>
>
> 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)