Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 52809 invoked by uid 500); 2 Jul 2002 10:13:18 -0000 Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-users@xml.apache.org Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 52797 invoked from network); 2 Jul 2002 10:13:17 -0000 Date: Tue, 2 Jul 2002 12:09:35 +0200 From: Christian Haul To: cocoon-users@xml.apache.org Subject: Re: strange database problem Message-ID: <20020702120935.Y4634@bremen.dvs1.informatik.tu-darmstadt.de> Reply-To: haul@dvs1.informatik.tu-darmstadt.de References: <20020630172406.GA23874@kompuart.pl> <200206301326.24481.proyal@apache.org> <20020701091350.R4634@bremen.dvs1.informatik.tu-darmstadt.de> <20020702095504.GC27920@kompuart.pl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20020702095504.GC27920@kompuart.pl> User-Agent: Mutt/1.3.22.1i Organization: Databases and Distributed Systems Group, Darmstadt University of Technology X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N 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 > > yes Option > > to . > > > > 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? Chris. -- C h r i s t i a n H a u l haul@informatik.tu-darmstadt.de 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. To unsubscribe, e-mail: For additional commands, e-mail: