Hi all,
there are some queries in bug-tracker that are real performance killers:
dbqd.bug-tracker.tcl.bug-procs.bug_tracker::bug::get_multirow.select_bugs: select nsdb0
takes 30903 ms
dbqd.bug-tracker.tcl.bug-procs.bug_tracker::bug::get_list.select_action_assignees: select nsdb0
takes 8768 ms
dbqd.bug-tracker.tcl.bug-procs.bug_tracker::bug::get_list.select_action_assignees: select nsdb0
takes 9219 ms
dbqd.workflow.tcl.case-procs.workflow::case::get_activity_log_info_not_cached.select_log: select nsdb0
takes 12560 ms
Can someone help?
We are using bug-tracker als support center and it is awful slow
Greetings,
Nima
