Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cocoon-users@xml.apache.org
Date: Tue, 4 Mar 2003 15:08:49 +0100
From: Leszek Gawron <ouzo@vip.net.pl>
To: cocoon-users@xml.apache.org
Subject: Re: big ESQL performance problem
Message-ID: <20030304140849.GB32052@kompuart.pl>
Mail-Followup-To: cocoon-users@xml.apache.org
References: <20030304135522.GA32052@kompuart.pl>
 <63FBA6DA-4E4A-11D7-A64B-000393B61B56@apache.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <63FBA6DA-4E4A-11D7-A64B-000393B61B56@apache.org>
User-Agent: Mutt/1.4i

On wto, mar 04, 2003 at 09:05:44 -0500, Peter Royal wrote:
> On Tuesday, March 4, 2003, at 08:55  AM, Leszek Gawron wrote:
> >I've been fighting with this all day and cannot find a cause. I'm 
> >using quite
> >fresh esql implementation to access Pervasive SQL 2000 database. The 
> >problem
> >is I have to pull 5500 rows from database. Performing query in 
> >Squirell SQL it
> >takes 3 second to execute and 16 to build output table (build squirell 
> >view).
> >The same query executed under cocoon takes 3.5 MINUTES! I'm desperate.
> >Pervasive is a weird database (the SQL access is built on very low 
> >lewel
> >core).
> 
> We are in the process of switching from pervasive to postgresql for 
> performance reasons. We have a 70k record table that takes *10 MINUTES* 
> to do a "SELECT COUNT(col) FROM table WHERE col2 = X" when col2 is 
> indexed. I have also noticed a very quick and steady decrease in 
> performance doing "SELECT COUNT(col) FROM table", *no where clause*, as 
> records are added.
Things are not so simple for me because I'm plugging into an existing system
(database change is impossible).

Second thing is that the same query that works reasonably fast under Squirell
JBDC client is a nightmare under cocoon
	LG
-- 
            __
         | /  \ |        Leszek Gawron            //  \\
        \_\\  //_/      ouzo@vip.net.pl          _\\()//_
         .'/()\'.     Phone: +48(600)341118     / //  \\ \
          \\  //  recursive: adj; see recursive  | \__/ |


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org