problem in production client

[Former Member]

dear friends,

i am facing problem on following issue.

a ALV report in devlopement client execute normally but the same report in the production client does not perform well.

that is unable to execute and there is excessive load on the database server.

can anybody suggest me where will be the exact problem.

thanks & regard,

vijay chavan.

[Former Member]

dear friends,

i am facing problem on following issue.

a ALV report in devlopement client execute normally but the same report in the production client does not perform well.

that is unable to execute and there is excessive load on the database server.

can anybody suggest me where will be the exact problem.

thanks & regard,

vijay chavan.

[Former Member]

Hi,

If you are using the ECC 6.0. then you can use the code inspector check( T : CODE :SCI). You might have called the loop inside the loop.

In devel client you might not have so many data's as in the production. So check your code in the code inspector.

Thanks

Yogesh

[Former Member]

Use transaction ST05 to help with database performance.

Rob

[Former Member]

Go step by step with break points and check the data selected in SELECT statements and then check for loop where you are geting values in final internal table. Wather all condition get true and data is updated in final table or not. Because some time final table is not updated for wrong data which not stisfy all conditions.

so best method put break points and check for data flow inside your program in production server

Rewards if useful.........

Minal