Forum OpenACS Q&A: Re: Ran out of database pools (pool2 pool3 pool1)

Posted by Eduardo Pérez on
The code is used to export an assessment to IMS QTI v1 file:*checkout*/openacs-4/packages/assessment/www/asm-admin/export/index.vuh
we need to do nested queries to generate the whole XML IMS QTI v1 file structure.
Is there an easier way?
We are not using a fourth pool now but I don't know how to change the code if there was only two pools (or if we needed that fourth pool in the future)
Maybe, should we be fetching all the data into memory first?
Is that the recommended design?