[Zope-CMF] Excessive time load when processing relations

[Dieter Maurer]

Rainer Thaden writes:
 > i developped a CMF Product for managing staff at a university
 > institute. There's one class 'Publication' and a class 'Employee' and
 > a publication is related to an 'Employee' by authorship (and coauthor).
 > To manage the relations between them i use mxmRelations.
 > The publications are displayed by a table which can be sorted by
 > author, date, etc.
 > So the task is to get the authors for all publications by
 > mxmRelations, get the names out of the 'Employee' instances and
 > display them.  
 > The problem is that it lasts up to 4 to 5 seconds until i get a
 > response where i (now) have only 6 publications to manage.
 > I use Zope 2.6 on W2k on a PIII 1,1 GHz.
 > 
 > What's consuming the load? Is it waking up the objects?
Use Zope's built in profiler to analyse situations like this:

    Control_Panel --> Debug Information --> Profiling


Dieter