Joshua,
have you profiled the same queries using ESQL ?
It could be useful having such a benchmark.
Best regards,
---------------------------------------------
Luca Morandini
GIS Consultant
[EMAIL PROTECTED]
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
> -----Original Message-----
> From: Joshua McCulloch [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 08, 2002 5:41 PM
> To: [EMAIL PROTECTED]
> Subject: SQLTransformer
>
>
> 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]>
