Performance of cnldst_shorttx within BAPI_NETWORK_MAINTAIN

[former_member182371]

Hi,

in a z report several calls to fm BAPI_NETWORK_MAINTAIN are done.

Using ST12 i can see that one cause of low performance is this select (within fm

CN_LDST_SHORTTX_UPDATE_PREPARE😞

    SELECT * FROM cnldst_shorttx BYPASSING BUFFER
                  APPENDING CORRESPONDING FIELDS OF TABLE cnldst_bt_upd
                  WHERE application = iv_application
                  AND object        = iv_object.

does anyone know if it is possible to improve the performance of this sentence?

Best regards.

[volker_borowski2]

Hello,

you need to include the field "LANGUAGE" to your WHERE clause.

This will give you a better utilisation of the primary key.

Volker

[former_member182371]

Hi,

Thanks Volker,

the question is that this select belongs to standard fm CN_LDST_SHORTTX_UPDATE_PREPARE.

So I´ve searched for OSS Notes and i´ve just found this one:
https://service.sap.com/sap/support/notes/691541
Note 691541 - Performance when creating change documents w/ several orders

it is a modification and i´m not sure if it will improve the above select.

So i´d like to know if there is another option.

Best regards.

[volker_borowski2]

Well,

you can create an additional index with

CLIENT+APPLICATION+OBJECT

this will bypass the LANGUAGE field.

It will cost some space, but it should clearly show, if adding the LANGUAGE filed would bring any benefit. If it does not do anything good, drop the index again, and I think nothing will really help then.

If it runs like hell, open an OSS message to request the change of code I mentionend for performance reasons.

Volker

[former_member182371]

Hi Volker,

i´ve tried your suggestion but the results unfortunately were not enough.

This is what i did afterwards:

1.- i found this thread:

http://scn.sap.com/message/6958102#6958102

2.- Based on this thread i added this:

CALL FUNCTION 'CO_ZF_DATA_RESET_COMPLETE'.

before every call of the bapi.

3.- i commented several WAIT UP TO X SECONDS.

And the performance improved considerably.

Best regards.