Antonio Gallardo wrote:
I guess it's the "load on the pool" that is unclear.Can you explain what you have in mind Sylvain? I dont understand what you have in mind.
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: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
