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 // \\
\_\\ //_/ [EMAIL PROTECTED] _\\()//_
.'/()\'. Phone: +48(600)341118 / // \\ \
\\ // recursive: adj; see recursive | \__/ |
