Return-Path: Delivered-To: apmail-xml-cocoon-dev-archive@xml.apache.org Received: (qmail 48211 invoked by uid 500); 5 Mar 2003 11:02:30 -0000 Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-dev@xml.apache.org Delivered-To: mailing list cocoon-dev@xml.apache.org Received: (qmail 48193 invoked from network); 5 Mar 2003 11:02:29 -0000 Received: from jester.kompuart.pl (HELO jester.vip.net.pl) (62.233.186.226) by daedalus.apache.org with SMTP; 5 Mar 2003 11:02:29 -0000 Received: by jester.vip.net.pl (Postfix, from userid 3013) id 2CD8023D41; Wed, 5 Mar 2003 12:02:00 +0100 (CET) Date: Wed, 5 Mar 2003 12:02:00 +0100 From: Leszek Gawron To: cocoon-dev@xml.apache.org Subject: Re: big ESQL performance problem - this one's weird Message-ID: <20030305110200.GD29308@kompuart.pl> Mail-Followup-To: cocoon-dev@xml.apache.org References: <3E64CED1.9050004@dff.st> <20030304161124.GB7821@kompuart.pl> <20030304162601.GK24538@bremen.dvs1.informatik.tu-darmstadt.de> <20030304164445.GB10285@kompuart.pl> <20030304171131.GA25711@bremen.dvs1.informatik.tu-darmstadt.de> <3E64F010.5090608@dff.st> <20030304212437.GB14460@kompuart.pl> <1046823387.936.33.camel@defiant.dff.local> <20030305103119.GA29308@kompuart.pl> <3E65D6FA.2040701@dff.st> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <3E65D6FA.2040701@dff.st> User-Agent: Mutt/1.4i X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N On śro, mar 05, 2003 at 11:52:42 +0100, Torsten Curdt wrote: > >got tired of waiting to finish so it will take at least 5 minutes (last > >time it took 9.9 minutes) cannot really tell how much it took - poor wget timed out > > Could you try the PreparedStatment testcase without > TYPE_SCROLL_INSENSITIVE, CONCUR_READ_ONLY and the Statement testcase PreparedStatement WITHOUT flags works just as fast as the Statement (results are similar : 4.7 - 5 seconds in each case) Statement WITH flags works slow as hell. So it's strictly connected with ResultSet flags ouzo -- __ | / \ | Leszek Gawron // \\ \_\\ //_/ ouzo@vip.net.pl _\\()//_ .'/()\'. Phone: +48(600)341118 / // \\ \ \\ // recursive: adj; see recursive | \__/ |