Re: big ESQL performance problem

2003-03-04 Thread Leszek Gawron
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

Re: big ESQL performance problem

2003-03-04 Thread Peter Royal
On Tuesday, March 4, 2003, at 09:08 AM, Leszek Gawron wrote: Things are not so simple for me because I'm plugging into an existing system (database change is impossible). We struggled with that for about two years before giving up (of course the existing system used the pervasive btrieve api

Re: big ESQL performance problem

2003-03-04 Thread Leszek Gawron
On wto, mar 04, 2003 at 03:21:27 +0100, Steven Noels wrote: Leszek Gawron wrote: 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, How does the rest of your pipeline looks like? Can

Re: big ESQL performance problem

2003-03-04 Thread Upayavira
On wto, mar 04, 2003 at 03:21:27 +0100, Steven Noels wrote: Leszek Gawron wrote: 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, It sounds like people are doubting ESQL, so it is

Re: big ESQL performance problem

2003-03-04 Thread Leszek Gawron
On wto, mar 04, 2003 at 04:34:52 -, Upayavira wrote: On wto, mar 04, 2003 at 03:21:27 +0100, Steven Noels wrote: Leszek Gawron wrote: 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

big ESQL performance problem

2003-03-04 Thread Leszek Gawron
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

Re: big ESQL performance problem

2003-03-04 Thread Steven Noels
Leszek Gawron wrote: 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, How does the rest of your pipeline looks like? Can you post the relevant sitemap snippet? /Steven -- Steven