BW system tuning - 4-CSDN博客

4. What are the factors to consider while extracting data from source system?

Data load performance can be affected by following key aspects.
Customer exits. à Check with RSA3, SE30 and ST05

Resource utilization. à SM50 / SM51

Load balancing. à SM50 / SM51 (Configure ROIDOCPRMS)

Data package size.

Indices on tables. à ST05

Flat file format.

Content Vs generic extractor. The size of the packages depends on the application, the contents and structure of the documents. During data extraction, a dataset is collected in an array (internal table) in memory. The package size setting determines how large this internal table will grow before a data package is sent. Thus, it also defines the number of Commit's on DB level.
Use RSMO and RSA3 to monitor the load.

Indices can be built on Data Source tables to speed up the selection process.
If there is a poor performance in data load, refer the following note
Note 417307 - Extractor package size: Collective note for applications.
If you define selection criteria in your Info Package and the selection of the data is very slow, consider building indices on the Data Source tables in the source system.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/768773/viewspace-627547/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/768773/viewspace-627547/