Very Nice.<br><br>Have a nice holiday :-)<br><br><div class="gmail_quote">On Sun, Oct 26, 2008 at 3:58 PM, Roché Compaan <span dir="ltr"><<a href="mailto:roche@upfrontsystems.co.za">roche@upfrontsystems.co.za</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi Fabio<br>
<br>
The funkload tests were project specific. I plan to write up my findings<br>
and to do benchmarks on a standard Plone instance and blog about it.<br>
This will unfortunately have to wait since I'm on holiday this week :-)<br>
<font color="#888888"><br>
--<br>
</font><div class="Ih2E3d">Roché Compaan<br>
Upfront Systems <a href="http://www.upfrontsystems.co.za" target="_blank">http://www.upfrontsystems.co.za</a><br>
<br>
</div><div><div></div><div class="Wj3C7c">On Sun, 2008-10-26 at 15:54 -0200, Fabio Rizzo Matos wrote:<br>
> Hi Roché,<br>
><br>
> I can see your funkload profile?<br>
><br>
> On Sun, Oct 26, 2008 at 3:43 PM, Roché Compaan<br>
> <<a href="mailto:roche@upfrontsystems.co.za">roche@upfrontsystems.co.za</a>> wrote:<br>
> On Sat, 2008-10-25 at 09:20 +0200, Hedley Roos wrote:<br>
> > > Have you measures the time needs for some "standard"<br>
> ZCatalog queries<br>
> > > used with a Plone site with the communication overhead<br>
> with memcached?<br>
> > > Generally spoken: I think the ZCatalog is in general fast.<br>
> Queries using a<br>
> > > fulltext index are known to be more expensive or if you<br>
> have to deal with<br>
> > > large resultsets or complex queries.<br>
> > ><br>
> ><br>
> > No I haven't. Roche Compaan has done extensive benchmarking<br>
> using<br>
> > funkload testing plain catalog vs module level cache vs<br>
> memcached, but<br>
> > the tests are more about page serving than catalog query<br>
> time. I'll<br>
> > ask him to comment more on that.<br>
><br>
><br>
> I actually did some profiling as well and catalog searches<br>
> were just too<br>
> damn slow. The average execution time for searchResults was<br>
> 100<br>
> milliseconds and this is why I told Hedley we should do some<br>
> caching at<br>
> query level in the first place. I experimented with this idea<br>
> a couple<br>
> of years back but wasn't successful due to inexperience. I was<br>
> trying to<br>
> cache brains which obviously leads to persistency bugs. This<br>
> time around<br>
> it was obvious to me that we should cache the IISet result<br>
> sets.<br>
><br>
> I suspect specific indexes are just performing suboptimally<br>
> and needs to<br>
> be improved. ExtendPathIndex in Plone seems to be one of them.<br>
><br>
> The effect on performance is really awesome, now we just need<br>
> to fine<br>
> tune the implementation.<br>
><br>
> --<br>
> Roché Compaan<br>
> Upfront Systems<br>
> <a href="http://www.upfrontsystems.co.za" target="_blank">http://www.upfrontsystems.co.za</a><br>
><br>
><br>
> _______________________________________________<br>
> Zope-Dev maillist - <a href="mailto:Zope-Dev@zope.org">Zope-Dev@zope.org</a><br>
> <a href="http://mail.zope.org/mailman/listinfo/zope-dev" target="_blank">http://mail.zope.org/mailman/listinfo/zope-dev</a><br>
> ** No cross posts or HTML encoding! **<br>
> (Related lists -<br>
> <a href="http://mail.zope.org/mailman/listinfo/zope-announce" target="_blank">http://mail.zope.org/mailman/listinfo/zope-announce</a><br>
> <a href="http://mail.zope.org/mailman/listinfo/zope" target="_blank">http://mail.zope.org/mailman/listinfo/zope</a> )<br>
><br>
><br>
><br>
><br>
> --<br>
> Fábio Rizzo Matos<br>
> ThreePointsWeb<br>
> <a href="mailto:fabiorizzo@threepointsweb.com">fabiorizzo@threepointsweb.com</a><br>
> <a href="http://www.threepointsweb.com" target="_blank">http://www.threepointsweb.com</a><br>
> +55 61 3202-6480<br>
><br>
> Python, Zope e Plone com quem entende do assunto!<br>
> _______________________________________________<br>
> Zope-Dev maillist - <a href="mailto:Zope-Dev@zope.org">Zope-Dev@zope.org</a><br>
> <a href="http://mail.zope.org/mailman/listinfo/zope-dev" target="_blank">http://mail.zope.org/mailman/listinfo/zope-dev</a><br>
> ** No cross posts or HTML encoding! **<br>
> (Related lists -<br>
> <a href="http://mail.zope.org/mailman/listinfo/zope-announce" target="_blank">http://mail.zope.org/mailman/listinfo/zope-announce</a><br>
> <a href="http://mail.zope.org/mailman/listinfo/zope" target="_blank">http://mail.zope.org/mailman/listinfo/zope</a> )<br>
<br>
<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Fábio Rizzo Matos<br>ThreePointsWeb<br><a href="mailto:fabiorizzo@threepointsweb.com">fabiorizzo@threepointsweb.com</a><br><a href="http://www.threepointsweb.com">http://www.threepointsweb.com</a><br>
+55 61 3202-6480<br><br>Python, Zope e Plone com quem entende do assunto!<br>