Slow performance with Acu4GL for DB2 vs. Vision

0 Likes

Problem:

Migrating from Vision files to using a database to house data, a significant decrease in performance was experienced.

The DBA found that temporary tables of  600,000 rows are being created for each START that is done in the COBOL program.

Tuning of the database has had some positive effect, but not enough to bring performance into an acceptable range.

Resolution:

Programmatically implementing the use of the WHERE CONSTRAINT dramatically increased performance.

Documentation of the WHERE CONSTRAINT can be found in the Acu4GL User's Guide, Chapter 9: Performance and Troubleshooting, section 9.1 Performance Issues.

Old KB# 2826
Comment List
Related
Recommended