Joshua McCulloch wrote:

>The queries are definitely not taking 130ms outside of
>cocoon.
>

Can you put numbers on this? How much does it take to do the same 
queries in a simple java program? (setup connections, start timer, 
execute queries, stop timer)

And on another note: does it also takes 130 ms if the SQLTransformer is 
already executed some times? The first time, you have overhead in 
creating connections etc, while after some times, the connections are 
taken from a pool.

>
>What do you mean by turning off debugging? I've
>changed the logging status to ERROR, and saw some
>improvement. What did you turn off, and how did you do
>so?
>

That's what I meant: change logging status to ERROR. I'm not sure though 
if this can still be done on one place, or if there are more places 
nowadays where you can reduce the logging level (yeah, I know, my 
in-depth days of Cocoon are some time behind me already. I hope I can 
get to work on some Cocoon project again, but that won't be in the near 
future).

>Thanks! :)
>

np, that's what we're here for ;)

tomK



---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Reply via email to