on 2005 Nov 17 3:54 AM
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!
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 IDs 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
64 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.