I am writing a program to flatten a BW hierarchy ( Vertical to Horizontal ).
In this program I have a recursive subroutine which is called 9 times( the hierarchy has 9 levels) for every record. There are around 500,000 records .
This is taking a long time to process..I have used sorted tables and it is still
taking more than 60,000 seconds to complete . There are no db operations within the loop...Can any one of you guys suggest any performane improvemet tip..coz i need to drastically reduce the runtime for this program.....any help from you guys would be appreciated......