We need to do serious performance tuning on bug-tracker and sadly we need to do it fast, otherwise openacs.org will be in trouble.
A) Bug Tracker needs pagination. Timo and I tried around a little bit, but did not get far (due to lack of time).
B) select_action_assignees takes for ages:
2081 ms select dbqd.bug-tracker.tcl.bug-procs.bug_tracker::bug::get_list.select_action_assignees: select nsdb0
select p.first_names || ' ' || p.last_name as name,
crum.user_id,
count(b.bug_id) as num_bugs
from bt_bugs b,
workflow_case_assigned_actions aa left outer join
workflow_case_role_user_map crum on (crum.case_id = aa.case_id and crum.role_id = aa.role_id) left outer join
persons p on (p.person_id = crum.user_id)
where b.project_id = '56106'
and aa.workflow_id = '216824'
and aa.action_id = '18'
and aa.object_id = b.bug_id
group by p.first_names, p.last_name, crum.user_id