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

Collapse
Posted by Nathan Lunt on
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
Posted by Eduardo Santos on
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.