cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Leszek Gawron <o...@vip.net.pl>
Subject big ESQL performance problem
Date Tue, 04 Mar 2003 13:55:22 GMT
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). Maybe this has something to do with scrolling rowsets or something. My
query is really simple:

<esql:execute-query>
<esql:query>
SELECT
	K.K_NIP AS Knt_NipE,
	B.GST_KntID AS Knt_KntId,
	B.GST_KntID AS Knt_Kod,
	K.K_GRUPA AS Knt_Grupa,
	K.K_Nazwa1 AS Knt_Nazwa1,
	K.K_Nazwa2 AS Knt_Nazwa2,
	K.K_NIP AS Knt_Nip,
	K.K_Adres1 AS Knt_Ulica,
	K.K_Miasto AS Knt_Miasto,
	K.K_KodPocztowy AS Knt_KodPocztowy,
	B.GST_TypMod AS SyncType
FROM
	gemini_syn_knt B LEFT OUTER JOIN kontrah K ON K.K_KOD = B.GST_KntId
WHERE
	B.GST_Datetime > CONVERT( '<xsp:expr>time</xsp:expr>', SQL_TIMESTAMP )
	AND K.K_GRUPA = 'ODB'
ORDER BY
	K.K_Nazwa1
</esql:query>
<esql:results>
<esql:row-results>
	<row>
		<esql:get-columns/>
	</row>
</esql:row-results>
</esql:results>
</esql:execute-query>

I'm not using any row skipping or limit clauses and still the performance is awful.


My second thought is that esql asks the database too often for metadata
information.


Any ideas ? It's crucial for me to solve this ASAP
regards
	LG
-- 
            __
         | /  \ |        Leszek Gawron            //  \\
        \_\\  //_/      ouzo@vip.net.pl          _\\()//_
         .'/()\'.     Phone: +48(600)341118     / //  \\ \
          \\  //  recursive: adj; see recursive  | \__/ |


Mime
View raw message