<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>On 27 Oct 2008, at 13:10, Roché Compaan wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div><br></div></blockquote><br><blockquote type="cite"><div><blockquote type="cite"><br></blockquote><br>Improving the performance of indexes is really really hard. In this case<br>I really don't think caching is a band-aid, it is a good solution. Even<br>with optimised indexes, you will find that you need caching to get<br>reasonable performance if you have a catalog with close to a million or<br>more documents indexed. Given a large enough catalog, I would argue that<br>caching is equally as necessary as having a large cache for a ZEO<br>client.<br><br>But caches expire and results get invalidated, and therefor we should<br>continue to optimise indexes. With some help we should be able to<br>contribute at this level too.<br><br>-- <br>Roché Compaan<br>Upfront Systems <a href="http://www.upfrontsystems.co.za">http://www.upfrontsystems.co.za</a><br></div></blockquote></div><div><br></div><div>Thanks to you and everyone else working on these sometimes thankless performance improvements.</div><div><br></div><div>--r</div><div> <span class="Apple-style-span" style="border-collapse: separate; 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; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 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; -webkit-text-decorations-in-effect: none; text-indent: 0px; -webkit-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div id="sig" style="line-height: 13px; margin-top: 4px; margin-right: 0px; margin-bottom: 4px; margin-left: 0px; padding-top: 2px; padding-right: 4px; padding-bottom: 2px; padding-left: 4px; font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 10px; color: black; "><div style="float: left; padding-top: 2px; padding-right: 6px; padding-bottom: 2px; padding-left: 6px; background-color: rgb(238, 238, 238); font-size: 10px; font-weight: bold; line-height: 13px; "><strong 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; ">Russ Ferriday</span></strong><span class="Apple-style-span" style="font-size: 10px; font-weight: bold; line-height: 13px; "><span class="Apple-converted-space"> </span>-<span class="Apple-converted-space"> </span></span><a href="http://topia.com/" title="visit topia.com" style="text-decoration: none; color: rgb(102, 102, 102); font-size: 10px; font-weight: bold; line-height: 13px; "><span class="Apple-style-span" style="color: rgb(102, 102, 102); font-size: 10px; font-weight: bold; line-height: 13px; ">Topia Systems</span></a><span class="Apple-style-span" style="font-size: 10px; font-weight: bold; line-height: 13px; "><span class="Apple-converted-space"> </span>- Open Source content management with Plone and Zope</span><br style="font-size: 10px; font-weight: bold; line-height: 13px; "><a href="mailto:russf@topia.com" style="text-decoration: none; color: rgb(102, 102, 102); font-size: 10px; font-weight: bold; line-height: 13px; "><span class="Apple-style-span" style="color: rgb(102, 102, 102); font-size: 10px; font-weight: bold; line-height: 13px; ">russf@topia.com</span></a><span class="Apple-style-span" style="font-size: 10px; font-weight: bold; line-height: 13px; "><span class="Apple-converted-space"> </span>- office: +44 2076 1777588 - mobile: +44 7789 338868 - skype: ferriday</span></div></div></div></span></div></span> </div><br></body></html>