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