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]>