cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Leszek Gawron <o...@vip.net.pl>
Subject Re: big ESQL performance problem
Date Tue, 04 Mar 2003 14:08:49 GMT
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


Mime
View raw message