Discussion Locked

Processing a very large database faster

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a very large database on an AS\400 that needs frequent updating. The last time I appended data to this database, the RPGLE program took 19 days to run. After the initial program completed, I tried calling the RPGLE program from a CL program to see if I could speed up the processing speed. The CL program used Override Database File (OVRDBF) commands to read blocks of records using the Records Retrieved At Once parameter
(NBRRCDS(30000)). The Override Database File commands appear to not have made any significant difference. If you have any advice on how to speed up the processing speed of the program, I would be very grateful.

5 replies

by bound4doom

Actually, there could be several hundred reasons for this, most common is the SQL commands themselves, a lot of people do the * when acessing databases in reality you should only select what you need. I see hundred of errors like this everyday whichare typically bad SQL Logic. Hard Question to answer without taking a look at what you are doing.

And Yes by spending a week going through and redoing the SQL statements for this I have taken process that ran for 25 days + and cut them down to a half hour. My Advice would be to bring someone in and look at what you are doing.

This discussion is closed to new replies.