BW: Delta loading slower than Full

[former_member283158]

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

[john_hawk · Accepted solution]

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

[former_member283158 · Accepted solution]

Thx for answer Jhon, you mean to add a range directly in the infopackage?

Regards

Rino

[john_hawk · Accepted solution]

Yes, use a "meaningless" selection in the InfoPackage against the key to force an efficient search. John Hawk

[former_member369415 · Accepted solution]

Just to confirm, tried this for a non-masterdata extractor (0UC_INSTFACTS) and entering a dummy filter made the FULL extraction way faster. Thanks!

[john_hawk]

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