|
midrange.com
All files in the system are journalled. There are about 12 transaction
files. Main transaction file has 7-8 million records per month. The
requirement is to move the monthly transaction data to the archives and
delete from the transaction files.
The data movement and deletion are done through RPG program under
commitment control. Initially there was no logical file based on date.
When the program ran it took 7hrs to move&delete 5 million records.
Tried the same by SQLRPG also. With commit it takes the same time.
Now following changes are done to improve performance.(Time taken
reduced by about 50%)
1. Logical file based on date.
2. Instead of committing after each pair of insert and delete, a
block of 1000 changes are committed.
What more can be done to optimize? RPG or SQLRPG is better for this?
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
