Sylvain Wallez wrote: <snip/>
I consider that getting a connection from the pool for each <execute-query> creates some unnececessary load on the pool. So I would go for the first solution (use the same connection).I will try that.
There will still be a need for new connections for sub queries, to reuse the same connection for sub queries as well one would need to cache the result from the embedding query. As I haven't used subqueries yet and don't know what typical use cases are, I can't evaluate the consequnces of such cashing, any ideas?
/Daniel Fagerstrom
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]