Skip to Content
Former Member
Oct 30, 2007 at 09:11 AM

Help with performane improvement



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