<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">And to clarify again, re: compatibility, I presume you're talking about people running the JDBCCacheLoader being able to stop their cache, switch to the RedcdRecJDBCCacheLoader, start again and still have their persistent data valid?<DIV><BR><DIV> <SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><DIV>--</DIV><DIV>Manik Surtani</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Lead, JBoss Cache</DIV><DIV>JBoss, a division of Red Hat</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Email: <A href="mailto:manik@jboss.org">manik@jboss.org</A></DIV><DIV>Telephone: +44 7786 702 706</DIV><DIV>MSN: <A href="mailto:manik@surtani.org">manik@surtani.org</A></DIV><DIV>Yahoo/AIM/Skype: maniksurtani</DIV><DIV><BR class="khtml-block-placeholder"></DIV><BR class="Apple-interchange-newline"></SPAN></SPAN> </DIV><BR><DIV><DIV>On 2 Feb 2007, at 03:12, Mircea Markus wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite">Hi,<BR><BR>Attached is a comparison between old and new impl on JDBC cache loading. Basically recursion was eliminated in the case of loadState and remove, and the put had a 50% optimization. All other operation are more or less a single db call, so nothing can really be programmatically improved. <BR><BR>The second image contains the design. Any comments are extremely welcomed :)<BR>Nothing is committed yet on CVS. <BR><BR>An open issue is the backward compatibility - working on that.<BR><BR>Cheers,<BR>Mircea<BR> <BR> P.S. <BR>How I've tested the performance (phps more easy to understand it from code :-)<BR> a tree with a TREE_DEPTH depth is created. Each node in the tree has a CHILDREN number of children. By default I've used TREE_DEPTH=7 and CHILDREN=3 which gave a total number of 3280 children. A node is selected at each depth from disjunct subtrees. ( i.e. in the benchmark used 7 nodes are selected). On all those nodes a certain operation is performed: loadState, remove etc. For benchmarking the put operation, the in memory tree nodes are Collections.shuffle(List<Fqn>), then they are (randomly) added to the database/classLoader.put. This procedure was repeated sever times. Also additional testing was performed in the case of put for deep trees (100 - 200 nodes) <BR><BR><BR><BR><SPAN><DIV><performance_comparison.PNG></DIV></SPAN><SPAN><DIV><design.png></DIV></SPAN><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">jbosscache-dev mailing list</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="mailto:jbosscache-dev@lists.jboss.org">jbosscache-dev@lists.jboss.org</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="https://lists.jboss.org/mailman/listinfo/jbosscache-dev">https://lists.jboss.org/mailman/listinfo/jbosscache-dev</A></DIV> </BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>