[jbosscache-issues] [JBoss JIRA] Created: (JBCACHE-1595) PARENT column needs an index

[Bill Middleton (JIRA)]

PARENT column needs an index
----------------------------

                 Key: JBCACHE-1595
                 URL: https://issues.jboss.org/browse/JBCACHE-1595
             Project: JBoss Cache
          Issue Type: Feature Request
      Security Level: Public (Everyone can see)
          Components: Cache loaders
    Affects Versions: 3.2.5.GA
         Environment: Oracle, other relations databases
            Reporter: Bill Middleton
            Assignee: Manik Surtani


We've struggled here for some time using JBC and recently got some help from a database expert.  He noticed correctly that our implementation does a lot of selectChildNames(), but that there exists no index on PARENT column in the database, only on the FQN column.  Creating one vastly improved our implementation.  I wonder if it's been considered as a default functionality before in JBC?

I suspect that there are a number of TimeoutException issues which are currently open here which could be resolved by implementing this.  Note that even simple hot-start times (where we dont actually fetch children at all in our app) dropped dramatically.

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