DTP load time for write optimized DSO

[former_member324038]

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

[former_member388307]

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

[former_member186445]

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?

[former_member186445]

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?

[former_member324038]

Hello Mario,

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

Regards,

Divyesh Khambhati

[former_member186445]

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