[Zope-CMF] Re: [dev] listFilteredActionsFor performance

[Dieter Maurer]

Tres Seaver wrote at 2005-4-25 15:11 -0400:
> ...
>> So it's hard to measure performance. But in general most time is spent
>> in expressions and in the WorkflowTool. Within the WorkflowTool,
>> worklists are by far the most expensive Actions.
>
>... because they involve catalog queries.  We could perhaps optimize
>that query via a dedicated TopicIndex for the 'review_state' portion.

Hm, the queries used for worklists are quite trivial.
In principle, they should be fast (at least if they would
not include the horribly inefficient "effective/expires" subquery
automatically added by the CatalogTool). Maybe, you try to remove
this subquery.

-- 
Dieter