<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">This is the 'batch' or 'distribute' pattern that crops up in many fields.<DIV><BR class="khtml-block-placeholder"></DIV><DIV>The best path is normally to understand what the conflicts are, and where the time is spent. </DIV><DIV>If in, this case, much time is spent in the preamble, and the actual inserts are quick, then diving down one time through the security layers and stuffing in 10 items is clearly better than 10 preambles, one for each insert.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>The other truism is that all optimisation is for a single case. There may be different answers for different cases. Ideally a single parameter would be enough to tune the system for different cases.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Good luck Roche, with the outcome, I'm excited to see some figures.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>--r.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><DIV><DIV>On 2 Nov 2007, at 15:24, David Binger wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">On Nov 2, 2007, at 10:58 AM, Lennart Regebro wrote:</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV> <BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">It seems to me having one thread doing a background consolidation one</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">transaction at a time seems a better way to go,</DIV> </BLOCKQUOTE><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Maybe, but maybe that just causes big buckets to get invalidated</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">in all of the clients over and over again, when we could accomplish</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">the same objective in one invalidation by waiting longer and executing</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">a bigger consolidation.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV> <BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">although certainly the</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">best thing would be to test all kinds of solutions and see.</DIV> </BLOCKQUOTE><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">No doubt about that.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><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; ">For more information about ZODB, see the ZODB Wiki:</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="http://www.zope.org/Wikis/ZODB/">http://www.zope.org/Wikis/ZODB/</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">ZODB-Dev mailing list<SPAN class="Apple-converted-space"> </SPAN>-<SPAN class="Apple-converted-space"> </SPAN><A href="mailto:ZODB-Dev@zope.org">ZODB-Dev@zope.org</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="http://mail.zope.org/mailman/listinfo/zodb-dev">http://mail.zope.org/mailman/listinfo/zodb-dev</A></DIV> </BLOCKQUOTE></DIV><BR><DIV> <SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Verdana; 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: Verdana; 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: Verdana; 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>Russ Ferriday</DIV><DIV><A href="mailto:russ@indepthoptics.com">russ@indepthoptics.com</A></DIV><DIV><FONT class="Apple-style-span" size="2"><SPAN class="Apple-style-span" style="font-size: 10px; line-height: 13px;"><B style="font-size: 10px; font-weight: bold; line-height: 13px; "><SPAN class="Apple-style-span" style="font-size: 10px; font-weight: bold; line-height: 13px; "><SPAN class="Apple-style-span" style="font-size: 10px; font-weight: bold; line-height: 13px; "><SPAN class="Apple-style-span" style="font-size: 10px; font-weight: bold; line-height: 13px; ">office: +44 118 3217026</SPAN></SPAN></SPAN></B></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" size="2"><SPAN class="Apple-style-span" style="font-size: 10px; line-height: 13px;"><B style="font-size: 10px; font-weight: bold; line-height: 13px; "><SPAN class="Apple-style-span" style="font-size: 10px; font-weight: bold; line-height: 13px; "><SPAN class="Apple-style-span" style="font-size: 10px; font-weight: bold; line-height: 13px; "><SPAN class="Apple-style-span" style="font-size: 10px; font-weight: bold; line-height: 13px; ">mobile: +44 7789 338868</SPAN></SPAN></SPAN></B></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" size="2"><SPAN class="Apple-style-span" style="font-size: 10px; line-height: 13px;"><B style="font-size: 10px; font-weight: bold; line-height: 13px; "><SPAN class="Apple-style-span" style="font-size: 10px; font-weight: bold; line-height: 13px; "><SPAN class="Apple-style-span" style="font-size: 10px; font-weight: bold; line-height: 13px; "><SPAN class="Apple-style-span" style="font-size: 10px; font-weight: bold; line-height: 13px; ">skype: ferriday </SPAN></SPAN></SPAN></B></SPAN></FONT></DIV><DIV><BR class="khtml-block-placeholder"></DIV><BR class="Apple-interchange-newline"></SPAN></SPAN></SPAN> </DIV><BR></DIV></BODY></HTML>