performance issue for VL01N transaction

[Former Member]

Hi,

When the user opens the VL01N transaction and enters the corresponding mandatory fields and if he press enter for going to,

Next screen it is geting problem, The problem is if single user opens that transaction it is taking 10-minutes to move to next

screen .If multiple users opens that transaction ,at this time it is moveing first screen to second screen with in seconds.

Can any one help me how to resolve this problem.

Thanks & Regards,

Anvesh Gummadapu.

[Former Member]

Hi,

Perform system Trace in Txn. ST12 for VL01N... and check which statements is taking a long time..

To perform traces the system should be at

Patchlevel 193 for 640 kernel

Patchlevel 145 for 700 kernel

Regards

GK.

[Former Member]

HI,

i have done the performance befor only,they are restricting the users inorder to go into this statement.this statement is ATP SERVER.HOW TO RESOLVE THIS PROBLEM.

REGARDS,

ANVESH GUMMADAPU

[ravi_lanjewar]

Hi,

The problem is if single user opens that transaction it is taking 10-minutes to move to next screen .
If multiple users opens that transaction ,at this time it is moveing first screen to second screen with in seconds.

First time it take longer time, read data from database store in buffer, Next time it read data from application buffer and display result very quick.

It problem while reading from database. Trace your program using transaction ST05 and post SQL execution plan.