<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000099">
<font face="Trebuchet MS">I installed 'ZopeProfiler' <br>
<br>
i can see the slow scripts and pages, but it's a bit biased i think
because if zope goes to 99% cpu, all scripts and pages run at that time
will become slow.<br>
Thus some results are not really that slow.<br>
<br>
I do notice that my suspected page is slow, but that's a page template,
and there is not very much out of the ordinary going on there. Just a
loop in tal over a sql result set.<br>
<br>
Should i test on a machine with only ME as user? That way I know what
is being called.<br>
</font><br>
Dieter Maurer wrote:
<blockquote cite="mid17867.35193.570683.527736@gargle.gargle.HOWL"
type="cite">
<pre wrap="">Marko Kruijer wrote at 2007-2-5 14:20 +0100:
</pre>
<blockquote type="cite">
<pre wrap="">...
The page loops over a results set from mysql, this set contains 400 -
500 results.
I've noticed that if it loops over 500 results instead of i.e. 20 the
page takes almost 3 to 4 seconds longer to load.
I've never seen this kind of behaviour before (i have seen it with bad
queries and such, but thats not the case here).
</pre>
</blockquote>
<pre wrap=""><!---->
You probably should profile your long running request to find out
where the time is spent.
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<font style="color: rgb(8, 82, 133);" face="Trebuchet MS" size="2">Met
vriendelijke groet,<br>
Marko Kruijer<br>
</font>
<br>
<div style="position: relative; width: 515px; height: 142px;">
<div style="position: absolute;"><img
src="cid:part1.04040708.09080005@mm-pro.nl">
</div>
<div style="position: absolute; top: 106px; left: 16px;">
<table
style="width: 515px; color: rgb(255, 255, 255); font-family: Trebuchet MS,Verdana,sans-serif; font-size: 9pt; font-weight: bold; line-height: 12px;"
cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td>Obiplein 6-10<br>
NL-1094 RB
</td>
<td><span
style="padding: 0px 16px 0px 0px; color: rgb(8, 82, 133);">T</span>
+31 (0)20 462 4910<br>
<span style="padding: 0px 16px 0px 0px; color: rgb(8, 82, 133);">F</span>
+31 (0)20 462 4919
</td>
<td><span
style="padding: 0px 16px 0px 0px; color: rgb(8, 82, 133);">M</span>
+31 (0)62 666 8489<br>
<span style="padding: 0px 16px 0px 0px; color: rgb(8, 82, 133);">E</span>
<a class="moz-txt-link-abbreviated" href="mailto:marko@mm-pro.nl">marko@mm-pro.nl</a>
</td>
</tr>
</tbody>
</table>
<table style="width: 515px;" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="padding-top: 8px; padding-left: 80px;"><a
class="moz-txt-link-abbreviated"
style="color: rgb(8, 82, 133); text-decoration: none;"
href="http://www.multimedia-professionals.nl">w w w . m u l t i m e d
i a - p r o f e s s i o n a l s . n l</a>
</td>
</tr>
</tbody>
</table>
</div>
<div style="clear: both;">
</div>
</div>
</div>
</body>
</html>