Skip to Content
0

DTP load time for write optimized DSO

Jun 02, 2017 at 10:00 AM

67

avatar image

Hello Folks,

I have one write optimized DSO and which is being load from 6 different PSA (ECC Sources).

Before Process chain start we have deletion step which delete request from PSA and WO DSO.

We have 2 set of 3 DTPs in parallel.

DTP1(Source 1) DTP2(Source 2) DTP3(Source 3)

DTP4(Source 4) DTP5(Source 5) DTP6(Source 6)

Initially this DTP loads (From PSA to WO DSO) were hardly taking 30 secs, gradually after few months its increase to 4-5 mins in case of only few records loaded.

This chain runs half hourly (48 times a day).

Any help, how I can reduce the run time, maybe I require to delete some request related technical tables. I read many posts ad documents on SDN but those are mostly related to standard DSO and DSO which contains many requests.

Please help.

Regards,

Divyesh Khambhati

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Mario Tibollo Jun 06, 2017 at 07:53 AM
0

any routines in the transformations? or any other read in field rules?

if you compare the logs, which step of the load is taking more time than before?

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hello Mario,

Neither we have Start routine nor field routine. Request generate step is taking more time.

Regards,

Divyesh Khambhati

0

do you delete the contents of the psa on a regular basis? the more records in the psa, the longer it will take to select the delta

0
Mario Tibollo Jun 06, 2017 at 07:53 AM
0

any routines in the transformations? or any other read in field rules?

if you compare the logs, which step of the load is taking more time than before?

Share
10 |10000 characters needed characters left characters exceeded
Md Ekram Jun 24, 2017 at 09:36 AM
0

It can be because of complex logic or lookup logic in transformation. Other way you can try to drop 'sap temp table' when no job run in the system then can try to observe the dataload performance.

Regards,
Md.Ekram

Share
10 |10000 characters needed characters left characters exceeded