Question Re: BW: Delta loading slower than Full in Technology Q&A

BW: Delta loading slower than Full

former_member283158 — Thu, 18 Oct 2018 14:39:48 GMT

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

Re: BW: Delta loading slower than Full

john_hawk — Thu, 25 Oct 2018 22:12:44 GMT

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

Re: BW: Delta loading slower than Full

john_hawk — Thu, 25 Oct 2018 22:13:39 GMT

Hi Gennaro,

Let me know if this helps.

John Hawk

Re: BW: Delta loading slower than Full

former_member283158 — Fri, 26 Oct 2018 08:57:14 GMT

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

Regards

Rino

Re: BW: Delta loading slower than Full

john_hawk — Tue, 18 Dec 2018 22:49:22 GMT

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

Re: BW: Delta loading slower than Full

former_member369415 — Wed, 01 Jul 2020 12:12:13 GMT

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