Performance Tuning Using RFC
Scenario: Existing program for many years ran successfully. It came to a point where this was no longer possible to run to completion due to the size of the database tables used in the program. To achieve the running of a report to completion without having a time-out event occur, I found that it was necessary to change the affected inner-join select to be converted into multiple RFC (remote function call) contained function module calls. The design is to obtain the header level data first, then use this in multiple smaller iterations in slice form for the select statement 'for all entries' clause.