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: > > > > > > > > > > > > > > >SELECT > > > > K.K_NIP AS Knt_NipE, > > > > B.GST_KntID AS Knt_KntId, > > > > B.GST_KntID AS Knt_Kod, > > > > K.K_GRUPA A

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: > > > > > > > > > > >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 03:21:27 +0100, Steven Noels wrote: > Leszek Gawron wrote: > > > > > > >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

Re: big ESQL performance problem

2003-03-04 Thread Leszek Gawron
On wto, mar 04, 2003 at 09:18:29 -0500, Peter Royal wrote: > 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 g

Re: big ESQL performance problem

2003-03-04 Thread Steven Noels
Leszek Gawron wrote: 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 Noelshttp:

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 wit

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

Re: big ESQL performance problem

2003-03-04 Thread Peter Royal
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