topic Re: hi in Application Development and Automation Discussions

hi

Former Member — Wed, 12 Dec 2007 06:40:24 GMT

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.

Re: hi

amit_khare — Wed, 12 Dec 2007 06:42:52 GMT

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

Re: hi

Former Member — Wed, 12 Dec 2007 06:44:28 GMT

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

Re: hi

Former Member — Wed, 12 Dec 2007 06:45:13 GMT

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.

Re: hi

Former Member — Wed, 12 Dec 2007 06:50:04 GMT

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

Re: hi

Former Member — Wed, 12 Dec 2007 16:04:31 GMT

What does the Short Dump say?