2012 Dec 17 3:59 PM
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.
2012 Dec 17 4:47 PM
Hello,
you need to include the field "LANGUAGE" to your WHERE clause.
This will give you a better utilisation of the primary key.
Volker
2012 Dec 17 4:47 PM
Hello,
you need to include the field "LANGUAGE" to your WHERE clause.
This will give you a better utilisation of the primary key.
Volker
2012 Dec 17 5:14 PM
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.
2012 Dec 17 5:41 PM
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
2012 Dec 18 12:09 PM
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.