I installed 'ZopeProfiler'

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.
Thus some results are not really that slow.

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.

Should i test on a machine with only ME as user? That way I know what is being called.

Dieter Maurer wrote:

Marko Kruijer wrote at 2007-2-5 14:20 +0100:

...
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).


You probably should profile your long running request to find out
where the time is spent.

--
Met vriendelijke groet,
Marko Kruijer

Obiplein 6-10
NL-1094 RB

T +31 (0)20 462 4910
F +31 (0)20 462 4919

M +31 (0)62 666 8489
E marko@mm-pro.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