[infinispan-issues] [JBoss JIRA] (ISPN-5517) JDBCBinaryStore size method should query count directly instead of iterating

[William Burns (JIRA)]

    [ https://issues.jboss.org/browse/ISPN-5517?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13095885#comment-13095885 ] 

William Burns commented on ISPN-5517:
-------------------------------------

I apologize for not updating this soon.  Unfortunately the JdbcStringBasedStore doesn't take into account for expired entries in the size method.  We could only count buckets that don't have an expired timestamp before our current time and then the other buckets that can have an expired entry would have to be manually read through.  This should be substantially faster than reading all entries though as JdbcBinaryBasedStore does currently.

> JDBCBinaryStore size method should query count directly instead of iterating
> ----------------------------------------------------------------------------
>
>                 Key: ISPN-5517
>                 URL: https://issues.jboss.org/browse/ISPN-5517
>             Project: Infinispan
>          Issue Type: Bug
>          Components: Loaders and Stores
>            Reporter: William Burns
>            Assignee: Ryan Emerson
>             Fix For: 8.0.0.Final
>
>
> JDBCBinaryStore size method iterates upon all of the rows in the database.  We should instead use the getCountRowsSql from the table manipulation just like JDBCStringBasedStore.



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