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

Tue Oct 16 10:22:03 EDT 2007

     [ http://jira.jboss.com/jira/browse/JBCACHE-1176?page=all ]

Mircea Markus resolved JBCACHE-1176.
------------------------------------

    Resolution: Done

Starting with 2.0 remove operations are executed to a single call to the DBMS. I've added logs (trace) that show the operations being executed whils removing the nodes from the database.

> 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: Mircea Markus
>             Fix For: 2.1.0.CR1, 2.1.0.GA
>
>
> 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