cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sylvain Wallez <sylvain.wal...@anyware-tech.com>
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 
pipeline).

>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

-- 
Sylvain Wallez                                  Anyware Technologies
http://www.apache.org/~sylvain           http://www.anyware-tech.com
{ XML, Java, Cocoon, OpenSource }*{ Training, Consulting, Projects }



---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org


Mime
View raw message