This is a document with suggestions to avoid performance issue in SAP BW ETL. it also can be referenced to find the bottleneck of the performance issue. it is the best practice.
Analyzing business and technical requirements Using ODS Objects the right wayUsing way Modeling data flowsModeling flows BW InfoProviders with precalculated dataBW data Efficient usage of BW MultiProviders