topic Re: Performance improvement for VB22 in Application Development and Automation Discussions

Performance improvement for VB22

Former Member — Fri, 30 Nov 2007 16:11:26 GMT

We are on 4.7 and using transaction VB22 to change Sales Deal. While calling this transaction in a custom report for promotions, we are creating new Condition Records. We are passing the following fields;

Sales deal number,

Customer (KOMG-HIENR),

Price Group (KOMG-KONDA),

Brand Code (KOMG-RKE_MVGR1),

SumProdCd (KOMG-PRODH2),

Amount (KONP-KBETR),

Unit (KONP-KONWA),

Valid From & Valid To.

It is working fine but gives issues (Time Out) only when there is large number of condition records (say 10,000 or more).

We can’t split it into several jobs because of the locking issue (The sales deal will be locked).

Is there any other way to do it.

Thanks.

Zahid

Re: Performance improvement for VB22

Former Member — Fri, 30 Nov 2007 16:20:58 GMT

Don't know if this helps or not, but check notes 144060 and 703410.

Rob

Re: Performance improvement for VB22

Former Member — Fri, 30 Nov 2007 20:21:24 GMT

Thanks Rob,

I been gone through these notes and was not sure also but now I will give them a hit.

Zahid.

Re: Performance improvement for VB22

Former Member — Fri, 30 Nov 2007 20:36:19 GMT

Well, they are old, but maybe...

Rob