[jbosscache-issues] [JBoss JIRA] Commented: (JBCACHE-1221) JDBCCacheLoader optimizations

[Mircea Markus (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBCACHE-1221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12429993#action_12429993 ] 

Mircea Markus commented on JBCACHE-1221:
----------------------------------------

1) batch cache put operations during state transfer was implemented, (also the non-batching code was significantly imprved).
For drivers that do not support batching this might be disabled:             cache.jdbc.batch.enable=true
A naive test (based on Derby db, JDBCCacheLoaderStateTransferTest.testMoreState()) shows a reduction from 28secs (no batching, old impl) to 15 secs (batching), i.e. about 45% improvement. I expect this to be even more when network calls are involved.

> JDBCCacheLoader optimizations 
> ------------------------------
>
>                 Key: JBCACHE-1221
>                 URL: https://jira.jboss.org/jira/browse/JBCACHE-1221
>             Project: JBoss Cache
>          Issue Type: Feature Request
>      Security Level: Public(Everyone can see) 
>          Components: Cache loaders
>            Reporter: Mircea Markus
>            Assignee: Mircea Markus
>             Fix For: 3.0.0.GA
>
>
> JDBCCacheLoader optimizations:
> - batch cache put operations during state transfer
> - batch put operations on transactions as follows:
>                     - batch all the puts and flush on transaction commit
>                     - if an remove takes place at some point, then flush before the remove (guess I'll also have to flush before a get takes place in the same transaction, have to check that)

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