Performance in reading Progress via OpenEdge

J

johanvdk

New Member
We are trying to improve the performance of reading a Progress database of 10 million records. This is read with Microsoft SSIS, using the OpenEdge technology. Limiting the query with where conditions did not improve this, as all records seem to be read anyway. So we have the feeling that OpenEdge will not solve this performance problem.

Looking into alternatives we think of the following:
- using a 3rd party commercial adapter (Pentaho JDBC, iWay)
- using Progress 4 gl to dump data into either sql server or flatfiles

Are this the possibilities, or can other options be evaluated.
 
The first thing that you ought to do is to run UPDATE STATISTICS. The SQL engine uses a cost based optimizer. If the stats have never been run it lacks the information to do a good job and you end up with a whole lot of table scans.

There may also be a lot of tuning opportunities available in the overall environment. That depends on the sophistication of the organization running your target db. Quite a few end users just go with the "out of the box" setup which is essentially untuned.
 
Without providing more detailed information one needs to speculate. Therefore I would guess that the poor performance problem is not caused by the underlying technology - instead I would say that it has to do with the fact that the fields on which your query filters are not sufficiently indexed.

Out of my experience I would say that poor database performance is mainly caused by queries which can not be resolved using an index and therefore end up in a table-scan.

Regards, RealHeavyDude.
 
What version of OpenEdge are you using? I'm making a SWAG since you said "OpenEdge" it's OE10.x something? What types of queries? Lots of joins? Are the fields used in the query part of the index(es)? Are you updating statistics on a regular basis? Are you using Type II storage for the table(s) and index(es) involved? Windows or *nix for the Progress DB?

There are at least a few possible options I can think of offhand, but it would help if you gave some more details.

EDIT: Tom and RHD beat me to it! ;)
 
You must log in or register to reply here.
Back
Top