Select takes too long

[Damanindahaus]

Hi bros,

i m using Progress v9.1D and i wanna get rows from 3 tables.

Code looks like this:
select a.name, u.preis, ud.date
from artikel a, usamtz u, umsatzdatum ud
where a.id = u.artikel
and u.nr = ud.nr

This querry runs in my SQL Explorer. The SQL Explorer just show 100 rows every result group. The count(*) of this select is over 400000 rows.

If I run this select over an ODBC Driver from .NET, I don't get any rows back after 1 Day.

How does it come? Are there any transfer limitations?

Regards

 

[RealHeavyDude]

First of all, you don't want to do this with 9.1d. To say it with Tom's words: It's ancient, obsolete and unsupported. Especially the implementation of the SQL92 engine in Progress V9 is slow and unstable - to say the least.

I am not aware of any limit of the ODBC driver so I am just guessing:

• Are you sure the query can be solved utilizing a proper index?
• Did you try update statistics on the database?
• Did you specify the transaction isolation level?

Nevertheless, I would urge you to try to work with smaller result sets.


HTH, RealHeavyDude.

 

[tamhas]

My first suggestion would be to do the join in the FROM clause instead of the WHERE. Especially with older versions, this seems to make a difference, possibly because it changes where the selection is made.

Second, I'm with RHD here in that returning 400000 rows is something I would question ... hard.

Ditto on the old version and needing to know the indexing.