Forum OpenACS Development: Re: Slow queries on Bug-Tracker. Some SQL Tunning

Collapse
6: Re: Slow queries on Bug-Tracker. Some SQL Tunning (response to 5)
Posted by Eduardo Santos on 03/16/10 01:14 PM
Hi Rocael,

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.

Collapse
7: Re: Slow queries on Bug-Tracker. Some SQL Tunning (response to 6)
Posted by Nathan Lunt on 03/16/10 01:39 PM
I don't have a lot of time to delve into this right now, but I wanted throw this out. Is there a chance that performance may be improved by doing two separate queries and appending the data to the list as necessary? Sorry I can't find the answer for myself, but I have seen situations where this is the case.
Collapse
8: Re: Slow queries on Bug-Tracker. Some SQL Tunning (response to 7)
Posted by Eduardo Santos on 03/16/10 01:52 PM
Hi Nathan,

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.