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. ouzo
-- __ | / \ | Leszek Gawron // \\ \_\\ //_/ [EMAIL PROTECTED] _\\()//_ .'/()\'. 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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>