Forum OpenACS Development: Re: Slow queries on Bug-Tracker. Some SQL Tunning
I'm still using 8.2, because I didn't have time to upgrade my OpenACS version to be compatible with 8.3 and beyond.
the problem is the left outer join. However, if we don't use it, the data won't be in the format the list wants to. So, I'm out of ideas.
It seems like there's a view in Worflow wich joins the party_approved_member_map and it's also very slow. I don't see how to improve it without change the whole datamodel for the workflow and bug-tracker.
Thank you very much for your answer, but I don't think this is the case. The list is very complicated with filters and pagination, and my guess is that list builder will need all the data in the same multirow.
Anyway, I'll try to follow your suggestion and see what happens.