On 02.Jul.2002 -- 03:09 PM, Leszek Gawron wrote: > On Tue, Jul 02, 2002 at 12:09:35PM +0200, Christian Haul wrote: > > On 02.Jul.2002 -- 11:55 AM, Leszek Gawron wrote: > > > > Since multiple "important" DBMSs have problems with checking for > > > > multiple result sets, it has been disabled by default for the current > > > > CVS version. It can be re-enabled by using > > > > <esql:allow-multiple-results>yes</esql:allow-multiple-results> Option > > > > to <esql:connection/>. > > > > > > > > Please try again with a snap shot newer than 2002-06-28 > > > > > > It works quite fine with only one small "but": I was using cocoon version from > > > april ( 2002.04.20 i think ). The response times (after compiling the xsp > > > page) where somewhere about 80-190 ms. Now it's 200-400 ms and sometimes more. > > > What may cause such great difference in response times? The xsp file is really > > > simple: it does select * from tablename only and outputs all columns. The > > > recordset retrieved contains 23 records (about 20 columns each). > > > > Mmmh, nothing that comes to mind should have a significant effect on > > performance. Someone suggested using a different driver, so, did you > > measure the different response times with the same driver? Does > > performance degenerate over time?
> It is the very same jadozoom driver. I cannot tell if the performance > degenerates but I think not. The difference is significant though. Just double checking. You've upgraded from 2.0.2 to 2.1-dev (snapshot), right? Could you try the same with a 2.0.3 CVS version? (Don't know enough about WinCVS www.wincvs.org to give instructions, this is command line cvs usage) cvs -d :pserver:[EMAIL PROTECTED]:/home/cvspublic login password: anoncvs cvs -d :pserver:[EMAIL PROTECTED]:/home/cvspublic checkout -r cocoon_2_0_3_branch xml-cocoon2 Build cocoon: cd xml-cocoon2 bash build.sh -Dinclude.webapp.libs=yes webapp WAR is in build/cocoon/ Remember to clear $TOMCAT/work before restarting. TIA. Chris. -- C h r i s t i a n H a u l [EMAIL PROTECTED] fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08 --------------------------------------------------------------------- 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]>