[jboss-jira] [JBoss JIRA] Created: (JBCACHE-1176) Bad performance when deleting a large tree from JDBCCacheLoader

[gmeroz (JIRA)]

Bad performance when deleting a large tree from JDBCCacheLoader 
----------------------------------------------------------------

                 Key: JBCACHE-1176
                 URL: http://jira.jboss.com/jira/browse/JBCACHE-1176
             Project: JBoss Cache
          Issue Type: Bug
      Security Level: Public (Everyone can see)
          Components: Cache loaders
    Affects Versions: 2.0.0.CR1
            Reporter: gmeroz
         Assigned To: Manik Surtani


When using JDBCCacheLaoder and trying to delete the hole tree:

using: cache.getCache().removeNode(Fqn.ROOT)

it takes a long time which may cause transaction timeouts when running on application server.

it seems that each node is deleted seperately instead of using one sql command.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira