hi

[Former Member]

hi pls help me ,

my report is working properly in developement client .

But it is going to Dump and performance is less in Quality and Production clients.

so is there any chance to increase the performance pls reply me soon for good points.

[amit_khare]

Refer the link for performance tuning -

http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm

When things come to performance you need to take care of certain things. There should be no mulitple SELECT on a same table. If it required, select data in an internal table and Read accordingly.

Do not use SELECT inside the loop unless it cannot be avoided.

Avoid nested loops instead use READ inside the loop.

Clear work areas wherevr possible.

Regards,

Amit

[Former Member]

Hi chaaya,

Check your report , for all select statements, ans use proper select statements,

use into table itab instead of into wa

use select single instead of select upto 1 rows

like ..

thanx

vinesh

[Former Member]

Hi,

You can improve the performance of report.

Few are tips.

Avoid nested loop.

Avoid nested select statements.

Avoid move corresponding.

Avoid into corresponding fields of table, instead you can write into table.

And please search in SDN in can you plenty of performance tips.

thanks,

Sriram Ponna.

[Former Member]

hi chaaya ,

set break points at various lines of code and try to find the area where u r getting dump. dbug the code in check the data & revert.

-maharshi

[Former Member]

What does the Short Dump say?