The queries are definitely not taking 130ms outside of cocoon. 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?
Thanks! :) - Josh --- Tom Klaasen <[EMAIL PROTECTED]> wrote: > Hi Joshua, > > Did you perform the same test outside of cocoon? You > should check how > long it actually takes for MySql to answer your > query. If this is much > faster than those 130 ms, there might be a problem. > > Also note that turning of debugging in Cocoon has > given me a 10 times > speedup once. Maybe you don't consider 13ms for 2 > queries so slow ;-) > > Please keep us posted on your findings, > tomK > > > Joshua McCulloch wrote: > > >Hello, > > > >I've been looking at page generating times with the > >profiler. I am finding that SQLTransoformer is > taking > >a huge amount of time to do what I consider simple > >queries. For example, a page that has two minor > >queries takes about 130ms to complete. > > > >Combined there are about 20 rows being returned. > Would > >you expect lower times? > > > >Running: > >Cocoon 2.0.2 > >Orion Server 1.5.4 > >Jdk 1.3.1 > >Mysql 3.23.49 > >MM jdbc drivers > > > >__________________________________________________ > >Do You Yahoo!? > >Sign up for SBC Yahoo! Dial - First Month Free > >http://sbc.yahoo.com > > > >--------------------------------------------------------------------- > >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]> > > > > > > > > > > > > > > > --------------------------------------------------------------------- > 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]> > __________________________________________________ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com --------------------------------------------------------------------- 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]>
