cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From o...@kompuart.pl (Leszek Gawron)
Subject Re: strange database problem
Date Thu, 04 Jul 2002 06:38:23 GMT
> 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>


Mime
View raw message