perform checking in report

[Former Member]

how can i check the performance inside the program code without going to the transaction st05 outside of program.

Thanks in advance

Baidyanath

[Former Member]

Hi,

You can check your performance check by <b>code inspector or extended pro</b>gram check- select menu bar in that goto 'program'->check->code inspector or extended program check.

And also you can checkout the performance issue by manually checking the program and following are the some of tips you use .

-Try to avodid joins, nested loops, dont write select statements within loop.

-- Write the select statement with required field names instead of all fields (*) which avoids the performance issue.

- Along with selected field names you may also take care in where condition: you should use only key fields in the where conditions and also maintain the sequence of key fields which they occurred in table if possible.

- Suppose if you use the non-key fields in where condition it makes lot of performance issues and there is no options to use key-fields then you have to create the secondary index for those non-key fields.

-use always binary search for READ statements.

<b>Reward with points if helpful</b>

Regards,

Vijay

[Former Member]

Hi

After Activating your code

follow this path

GOTO PROGRAMS -> CHECK -> CODE INSPECTOR/ EXTENDED PROGRAMING CHECK

you will find both options in newer vertions and only ECP in old vertions

you can choose any one

beter to go for CODE INSPECTOR

there you will get all the detailsw of errors wornings etc ....

you need to maintain all the points as 0 then only the program will execute perfectly

if you click on the points then it will show where exactly you need to change

reward if usefull