topic Re: program execution time in Application Development and Automation Discussions

program execution time

Former Member — Tue, 23 Dec 2008 05:59:43 GMT

Hi all,

i have created a report which inlclude posting dates. if i enter the period of 1 year it takes abt 3 mins. to execute it, as i tried the same in table from where the data comes , the table is aslo taking almost same time but it will not do, so just plzz tel me that is there any tips or trick so that i can reduce this execution time..??

thanx..

Re: program execution time

Former Member — Tue, 23 Dec 2008 06:03:18 GMT

Hi...

Just check for basic performance issues.. and try to avoid them...

like.. mulitple selects on the same table.. loop within loop.... looping on a table and deleting the same table....... check for not initial condition before doing 'for all entries'.....stuff like these... .and also check whether its possible to go for alternative database tables as wel...

Re: program execution time

Former Member — Tue, 23 Dec 2008 06:12:31 GMT


> Hi...
> 
> 
> Just check for basic performance issues.. and try to avoid them...
> 
> like.. mulitple selects on the same table.. loop within loop.... looping on a table and deleting the same table....... check for not initial condition before doing 'for all entries'.....stuff like these... .and also check whether its possible to go for alternative database tables as wel...

thanx, but its taking same time if i use by se11 and see it by giving same conditions in it. so there is no prob of loops... and im using only two select statement and using the table only once..

Re: program execution time

Former Member — Tue, 23 Dec 2008 06:15:27 GMT

If u have tried all the things and now you are out of options then last option is

Create Index for the table

Hope this will solve your problem...

Regards

Sas

Re: program execution time

Former Member — Tue, 23 Dec 2008 06:21:41 GMT

Hi,

Goto SE30 enter ur report name and execute, once it is done click analyze it will show the analysis of execution that whether database hits are taking more time or ur abap statements or the system,

Once u see the analysis then u can concentrate to reduce the performance overhead of that particluar part.

кu03B1ятu03B9к

Re: program execution time

Former Member — Tue, 23 Dec 2008 06:31:32 GMT


> If u have tried all the things and now you are out of options then last option is 
> 
> Create Index  for the table
> 
> Hope this will solve your problem...
> 
> Regards
> Sas

thanx..

can u tel me in bit details abt creatng index plzz...

thanx....

Re: program execution time

Former Member — Tue, 23 Dec 2008 06:36:34 GMT

Hi Nilesh,

Check these imp. blogs for basic performance issues:

The SQL Trace (ST05) u2013 Quick and Easy

The ABAP Runtime Trace (SE30) - Quick and Easy

Sachin

Re: program execution time

vinod_vemuru2 — Tue, 23 Dec 2008 06:53:00 GMT

Hi Nilesh,

First send us your select query with out seeing which its very dificult to draw the solution. There might be many reasons for performance issues. Suppose a select in CDHDR/CDPOS table u can't improve much by what ever care u take.

A select on BSEG can be improved by getting data from index tables BSAD/BSID/BSAK/BSIK table.

So first post ur query.

Thanks,

Vinod.

Re: program execution time

Former Member — Tue, 23 Dec 2008 06:55:39 GMT


> Hi,
> Goto SE30 enter ur report name and execute, once it is done click analyze it will show the analysis of execution that whether database hits are taking more time or ur abap statements or the system,
> Once u see the analysis then u can concentrate to reduce the performance overhead of that particluar part.
> 
> кu03B1ятu03B9к

thanx its the database which is taking the maximum time.. so whats next...?

Re: program execution time

Former Member — Tue, 23 Dec 2008 06:57:23 GMT


> Hi Nilesh,
> First send us your select query with out seeing which its very dificult to draw the solution. There might be many reasons for performance issues. Suppose a select in CDHDR/CDPOS table u can't improve much by what ever care u take.
> 
> A select on BSEG can be improved by getting data from index tables BSAD/BSID/BSAK/BSIK table.
> So first post ur query.
> 
> Thanks,
> Vinod.

thanx..

this is query..

select budat belnr into (itab-budat,itab-belnr) from bkpf
where budat between  budat-low and budat-high and bukrs in bukrs

Re: program execution time

vinod_vemuru2 — Tue, 23 Dec 2008 07:02:44 GMT

Hi,

It seems this is select andselect. Replace this with FOR ALL ENTRIES logic.

Always make sure that where clause fields matches with the order they appear in data base

So try with below quesy. If doesn't get much improvement then use for all entries logic.

select budat belnr into (itab-budat,itab-belnr) from bkpf

where bukrs in bukrs AND budat between budat-low and budat-high.

Do you have data in bukrs and budat? If not u can't improve much. Because if first key field of table is empty then it takes long time.

Check these and get back.

Thanks,

Vinod.

Re: program execution time

Former Member — Tue, 24 Mar 2009 10:55:09 GMT