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.
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.