[jboss-user] [JBoss Cache] - Index on PARENT column vastly increases performance

Bill Middleton do-not-reply at jboss.com
Wed Dec 8 05:43:27 EST 2010

Bill Middleton [http://community.jboss.org/people/wjm] created the discussion

"Index on PARENT column vastly increases performance"

To view the discussion, visit: http://community.jboss.org/message/574738#574738

  We've fought for a long time to understand why we were getting TimeoutExceptions from JBC, even when the load was apparantly light.  With some help from a DBA we were able to determine that the problem was with node.getChildrenNames(), since that call selects from FQN via WHERE clause in Parent.  As our tree got larger the cost of a full tablescan on PARENT became completely unbearable.

The simple solution was to setup an index on PARENT like so in the oracle db


Doing this VASTLY improved our performance overall, and I'm wondering now if there is any reason not to request this as a feature/bugfix for the general population?

Reply to this message by going to Community

Start a new discussion in JBoss Cache at Community

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20101208/4f7a18d5/attachment.html 

More information about the jboss-user mailing list