> That looks bad, indeed. I will have a look at it but it will take some
> time to reproduce these values (gimme a week or so). I take your word
> for it that you haven't changed anything else around it like move the
> DBMS to another machine, upgrade your network, CPU, RAM, JDK, JDBC
> driver or anything else.
I've collected these timings today substituting only cocoon directories
>
> However, I will not be able to test against your setup and use a
> different DBMS / OS / JDK / Servlet-Container.
To eliminate my fault somewhere please download file from
http://ouzo.niebiosa.com/cocoon.rar (rar 3.0 packed - ca. 18 MB ) or
http://ouzo.niebiosa.com/cocoon.tar.gz - ca. 27 MB
It contains both cocoon versions (apidocs were stripped because of size but I
left the rest). I can also send you the database installation file but you'll
have to run in on Win32( or someone else who is willing to try to reproduce my
results)
> It would help to have some more information on the table, like number
> and type of columns, number of rows.
at the location http://ouzo.niebiosa.com/table.txt you will find as much table
information as I could get
the records I'm working on are at http://ouzo.niebiosa.com/records.txt
> If you care to do some experiments yourself, the ESQL stuff is fairly
> self-contained and does not depend on other changes in Cocoon. Thus
> it's only o.a.c.c.l.m.xsp/Esql*.java and o.a.c.c.l.m.xsp.java/esql.xsl
>
> The resulting java code produced from your XSP should be fairly
> similar with both versions, actually.
>
> The main difference should be the introduction of various switch
> statements to select different results. Those are outside the
> retrieval loop and so should not account for a big slow-down.
>
> The other major difference should be, that the current version does
> not check for another result set while the older version did (in a not
> JDBC compliant way - that was changed to be compliant and later
> disabled).
>
> Other things happend in the grouping / CallableStatement support which
> should not be used in your case.
What exactly should I do ?
ouzo
--
__
| / \ | Leszek Gawron // \\
\_\\ //_/ ouzo@vip.net.pl _\\()//_
.'/()\'. Phone: +48(600)341118 / // \\ \
\\ // recursive: adj; see recursive | \__/ |
---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
|