Skip to Content
avatar image
Former Member

DTP load time for write optimized DSO

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jun 06, 2017 at 07:53 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 06, 2017 at 07:53 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 24, 2017 at 09:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded