Joined: 31 May 2006 Posts: 200 Location: Netherlands
1) For starters, check if there are any 'select *' s in the program and see if all the fields are being used in the process, if they are not then select only those fields which are being used. Also if any of the fields not used are dropped later the program does not need changes, simple compile will do.
See if any of the queries can be clubbed together in to joins.This will improve the performance.
Remove any unnecessary calls to DB if present
2)If there are any if else loops , replace them with evaluate end-evaluates . To the extent possible avoid any backward GO TOs.
Understand the flow and to the extent possible adopt top down approach.
Break down the code into meaningful paragraphs where ever necessary.
Follow indentation strictly, it will not only improves the readability but helps you in understanding complex if else loops.
This is all I can think of for the present, If can get any useful info I will post down the line.