topic Re: performance problem in Application Development and Automation Discussions

performance problem

Former Member — Fri, 28 Nov 2008 09:33:31 GMT

Hi all

I have one issue like this

there is one report . on executing it , it is taking more exeution time . when the execution time limit is more than 1500 sec it is going for short dump.

i have debugged the program . i found at one select statement it is taking more time .

the select stmt is like (select * from rbkp) how should i know which fields i have to select instead of select * frm rbkp table. how should i know whether i have to increase the where conditions??

finally how should i reduce the execution time limit

Re: performance problem

Former Member — Fri, 28 Nov 2008 10:01:19 GMT

Hi,

You can ask to your BASIS team to change the execution time before it goes to dump. I think the 1500sec is too short.

In your RBKP issue check the program on what fields is use then for performance wise make a one select and append in your created internal table then make a loop, in your WHERE condition check if you can use primary key namely BELNR and GJAHR in your selection-screen. to reduce execution time it really depends on the way of selecting of data and how many is the data. Hope it helps

Re: performance problem

Former Member — Fri, 05 Dec 2008 19:18:44 GMT

How should i know which fields i have to select instead of select * frm rbkp table

This Depends on your application needs.

Check the internal table that needs to be filled

from rbkp table, and if it doesn't have all teh

fileds of rbkp, just extract those fileds that are

in the internal table.

If the internal table doesn't have any specific fields

and is just like rbkp, then check u r application

needs and retrieve those data,also change your internal table

with only those fields that are required in u r application.

How should i know whether i have to increase the where conditions??

Again Where condition depends on u r application,

try giving as many fields as possible in where condition

that helps to minimise the DB execution time.

It is suggestable to give all the key fields of the table

in the where clause for better performance if possible.

Re: performance problem

Former Member — Mon, 08 Dec 2008 05:33:15 GMT

Hi Pavan,

RBKP is a table having 129 fields.By using select * will result in execution of the program for a long time.Instead you can select the required fields from RBKP by checking which fields are being used from this table in the program.

It is always a good practice to use all the primary key fields of the table in the where condition of the select statement.If it is not possible to use a primary index then atleast any of the secondary index must be used which will improve the performance of the program.