cancel
Showing results for 
Search instead for 
Did you mean: 

Data load performance issue

Former Member
0 Kudos
58

I am loading more than two million records through a delta load from R/3. I saw the time to load each packet has progressively slown down from 10 second to 9 minutes. The whole load takes 12 hours and it still not finishes yet. I have run the stats and reorg tables. Anything else I can do to improve the performance?

Thanks for your help!

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

As the general poins: you have to follow the below points for performance:

1) Upload Sequence: Always load master data before transaction data

2) Parallelizing Upload :The subsequent load from PSA is parallel by requests

3)Transformation Rules: . If you discover a lot of time spent in transformation rules (e.g., via Data Load Monitor), check and improve the coding.

4)Dropping Indices before Loading :If your uncompressed F-table is small, drop indices before loading. In this case, it is faster to rebuild the index at the end of the load process instead of updating the index for each record loaded.

5)Buffering Number Range: The number range buffer for the dimension ID’s resides on the application server and reduces DB server accesses. For example, if you set the number range buffer for one dimension to 500, the system will keep 500 sequential numbers in memory and need not access the database.

6)Settings of Extractors: In general, small data package sizes are good for resource-constrained systems and big sizes are good for large systems.

7)Indices on DataSource tables :Indices can be built on DataSource tables to speed up the selection process.

With rgds,

Anil Kumar Sharma .P

All this information is copied from one the SAP document. You can find this document in this site , in performance link

Former Member
0 Kudos

Hi Yan,

Welcoem to SDN!!

There could be multiple reasons for this:

1. Your update rules might have some routine. Based on the data in each data package the load time might be different.

2. Make sure you do not have the indexes created on your cube. If so, then delete the indexes.

3. May be there are not enough system resources.

Bye

Dinesh