topic Program execution time in Application Development and Automation Discussions

Program execution time

Former Member — Thu, 31 Aug 2006 12:04:48 GMT

Hi ,

here i have an issue related to the program execution ,we have two systems ie dv1 and pf1 .

where pf1 is the current system .

while running a report (result analysis report )

on pf1 its taking 1 hr to complete the execution .

whereas in dv1 its just taking HALF an hour .

NOTE: i found there where no changes to both the program .

Can anybudy give me the hint where the problem would be .

Thanks ,

vinay

Former Member — Thu, 31 Aug 2006 12:07:34 GMT

May be in pf1 load on database is more than in df1

Former Member — Thu, 31 Aug 2006 12:10:07 GMT

hi Vinay,

It could be that in one system it has less number of records to process than the other system..

i.e, pf1 server has many records than dv1

Regards,

santosh

Message was edited by: Santosh Kumar P

Former Member — Thu, 31 Aug 2006 12:13:23 GMT

Hi,

there could be different problems:

- different using of the index from the database-optimizer -> use SQL-trace (ST05) and compare

- different systemprofils -> use the report RSPARAM and compare

- different traffic on the systems -> take a look in the SM51 what happen on the systems

- different hardware

Regards,

Stefan

Former Member — Thu, 31 Aug 2006 12:14:45 GMT

hi,

may be your dv1 system has less no of records than the pf1 system to be perform..

regrds,

vishal

Former Member — Thu, 31 Aug 2006 12:35:32 GMT

Hi ,

Thanks for your consern ,this not related to records hardware problem.

i have checked with that too.

Thanks ,

vinay .