Forum OpenACS Q&A: Re: Ran out of database pools (pool2 pool3 pool1)
We don't really want to force everyone to define four pools be default. Nor do we want the installation of a particular package force people to rewrite their init .tcl file.
The main reason, though, as mentioned above in 2003 ... DEEPLY NESTED DB_FOREACH LOOPS WILL NOT SCALE. Joining multiple tables using a column index DOES SCALE.
Can you describe what you're trying to do in this deeply nested query structure in more detail?