Skip to Content

BW: Delta loading slower than Full

Hi to all,

in the BW SYSTEM of my new customer happens that the delta loading of the standard extractors is slow compared to the number of recrords trasferred and very slow compared to full loading.

Just think that to load 5 records in PSA from a Master data extractor it need of 7 seconds in full mode and 32 minutes in delta mode.

For two particular extractor ( 0cust_sales_attr - 0vendor_attr) the loading of 2 trasferred data lasts 39 minutes.

I notice that the difference between the operation of "data selection scheduled" and "record sent" ( for 2 records) is 30 minutes.

Assuming that :

no IDOC blocked in both system ( SM58);

the check in the source system with tcode RSA3 maked on the same datasources is very fast.

the full loading on the same data is very fast. the server processor is completely empty (SM50). the process we talk abou contemplate only the dataloading on the PSA.

Anyone have an idea to speed and tuning this delta mode?

Kind regards

Rino Sica

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 25, 2018 at 10:12 PM

    Hi Gennaro,

    Delta is not always faster or better for master data. The delta pointer may use a single pointer "Creation date" for the delta, and ignore changed resords entirely! Use the full extractor for Master data.

    For large master data, like Production Order, I have found is useful to add a "meaningless" selection range to the key "00000000000" to "9999999999" . This seems to force a search along the key ti insure an efficient search.

    Let me know if this helps.

    John Hawk

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2018 at 10:13 PM

    Hi Gennaro,

    Delta is not always faster or better for master data. The delta pointer may use a single pointer "Creation date" for the delta, and ignore changed resords entirely! Use the full extractor for Master data.

    For large master data, like Production Order, I have found is useful to add a "meaningless" selection range to the key "00000000000" to "9999999999" . This seems to force a search along the key to insure an efficient search.

    Let me know if this helps.

    John Hawk

    Add comment
    10|10000 characters needed characters exceeded