Forum OpenACS Development: Re: ADP include multithreaded execution

Collapse
Posted by Dave Bauer on
It would be alot easier and straightforward, and I suspect, maintainable, if you just made the queries faster :)
Collapse
Posted by Malte Sussdorff on
Well, query execution time is not the issue here. I might have stressed the truth a bit with the 500ms, e.g. the projects page loads in 1.5seconds with the slowest query taking around 100ms. But as we are executing 130db queries on that page with 8 includes, I thought that having them rendered in parallel will make better use of the parallel execution capabilities of postgresql. At the moment we have 30 DB connections to the database and on average we use around 5 of these. So parallelization will make better use of the resources available, as we do not have many users in the system, but a ton of data.
Collapse
Posted by Malte Sussdorff on
Oh, and out of the 130 queries only 10 are slower than 10ms.