Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

hi

Former Member
0 Kudos

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.

1 ACCEPTED SOLUTION

amit_khare
Active Contributor
0 Kudos

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

5 REPLIES 5

amit_khare
Active Contributor
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

What does the Short Dump say?