Program execution time

[Former Member]

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]

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

[Former Member]

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]

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]

hi,

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

regrds,

vishal

[Former Member]

Hi ,

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

i have checked with that too.

Thanks ,

vinay .