cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From (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 (rar 3.0 packed - ca. 18 MB ) or  - 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

> It would help to have some more information on the table, like number
> and type of columns, number of rows.

at the location you will find as much table
information as I could get
the records I'm working on are at

> 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
> 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 ?
         | /  \ |        Leszek Gawron            //  \\
        \_\\  //_/          _\\()//_
         .'/()\'.     Phone: +48(600)341118     / //  \\ \
          \\  //  recursive: adj; see recursive  | \__/ |

Please check that your question  has not already been answered in the
FAQ before posting.     <>

To unsubscribe, e-mail:     <>
For additional commands, e-mail:   <>

View raw message