topic Re: Performance on Ztransaction in Application Development and Automation Discussions

Performance on Ztransaction

Former Member — Fri, 17 Oct 2008 19:45:15 GMT

Hello

I have a performance related issue regarding the Ztransaction i created which saves the notifications in the background using call transaction method(BDC) upon clicking save in the lastscreen.

so the whole data and validations are occur only before saving the transaction.

Sometimes it saves only in couple seconds and sometimes it takes minutes upto 20-30 min.

I know its not the program performance issue coz if it is a program issue it will take more time always i try to save...

I already did the extended check(SLIN) and there are no errors.

Can anybody suggest me where to start to checking this issue to fix apart from the program point of view?

do i need to check any kind of data locks and background jobs at the same time?

Please suggest me with the issue...

Thanks

Re: Performance on Ztransaction

Former Member — Fri, 17 Oct 2008 19:49:24 GMT

Hello,

First of all you need to check where's the performance problem. You can do this in the [performance analysis|http://help.sap.com/saphelp_nw04/helpdata/en/00/e0a73e5b7a424de10000000a114084/frameset.htm] and [The ABAP Runtime Trace (SE30) - Quick and Easy|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/7769] [original link is broken] [original link is broken] [original link is broken];.

You can find helpful information about performance in this blog [Performance of Nested Loops|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/7769] [original link is broken] [original link is broken] [original link is broken];

Regards.

Re: Performance on Ztransaction

Former Member — Fri, 17 Oct 2008 19:54:30 GMT

Does the longer execution time occur when the transaction hasn't been executed in a while (say early in the day)? Some standard SAP transactions are very slow the first time they are executed in a while.

Rob

Re: Performance on Ztransaction

Former Member — Fri, 17 Oct 2008 20:01:09 GMT

Thanks for your reply

It happens even after the several runs..since i control till i provide the data to the BDC of std transaction ..there is no control unless i get the error while processing.

Iam very sure and i saw its executed in 2 sec too.

Please let me know if ST05 or SE30 are the only solutions for this.

Thanks.

Re: Performance on Ztransaction

Former Member — Fri, 17 Oct 2008 20:16:13 GMT

Have you looked for performance notes for your SAP transaction?

Rob

Re: Performance on Ztransaction

Former Member — Fri, 17 Oct 2008 21:38:27 GMT

Thanks for your reply

where to look for performance notes for your SAP transaction?

By the way iam using Z transaction and saving entries thru SAP transaction using BDC call transaction

Tcodes iam using in BDC are IW31 and IW51

Thanks

Re: Performance on Ztransaction

Former Member — Fri, 17 Oct 2008 23:00:40 GMT

are you using update 'S' in your call transaction call? if yes remove that

Re: Performance on Ztransaction

Former Member — Sat, 18 Oct 2008 02:00:41 GMT

Thanks for your reply

You mean to say to remove 'S' and put only call transaction without update mode?

If i use update mode what would be the value Synchronous or Asynchronous?

Example :

Call transaction 'XXXX' using bdcdata

without Update mode? or Use update mode 'A'

Please let me know

Thanks

Re: Performance on Ztransaction

Former Member — Sat, 18 Oct 2008 02:02:18 GMT

use update 'A'. using 'S' is going to slow it down as then it will wait for all update tasks to finish

Re: Performance on Ztransaction

Former Member — Sat, 18 Oct 2008 02:42:52 GMT

I will try this with update mode 'A' and assign full points ans close the question.

Thanks