cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sylvain Wallez <>
Subject Re: SQLTransformer and Transactions
Date Sun, 15 Dec 2002 12:45:41 GMT
Antonio Gallardo wrote:

>Can you explain what you have in mind Sylvain? I dont understand what you
>have in mind.

I guess it's the "load on the pool" that is unclear.

What I'm saying is that I consider a waste of CPU to get a connection 
from the same pool for each <sql:execute-query> encountered in the 
document. The transformer can be made quicker by getting a connection 
either at the start of the document or at the first <sql:execute-query>, 
and close it in endDocument() or recycle() (this last one is better 
since endDocument() may not be called if an exception occurs in the 

>Sylvain Wallez dijo:
>>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).
>>Other thoughts from the database specialists out there ?


Sylvain Wallez                                  Anyware Technologies 
{ XML, Java, Cocoon, OpenSource }*{ Training, Consulting, Projects }

To unsubscribe, e-mail:
For additional commands, email:

View raw message