Logical database program running slowly

[former_member282968]

I have just reverted the earlier changes done in logical database program and it is in sync with the production version now.The reverted one in development is taking too long time while executed it for large range of data and leading to "Time out" error. Where as the production version is working correctly. Is there something I need to do because I checked every possible option and there is no change in the code.Please suggest.

[Former Member]

Hi Naveen,

        Can u elaborate the detail of logical database ....or paste ur code so we can analyze...

Thanks

Vijay SR

[GirieshM]

Hi Naveen,

Check with basis consultant, whether the time-elapse and memory parameters differ between PRD and DEV system.

WIth Regards,

Giriesh M

[former_member282968]

Can someone reply me for the posted question:

The logical DB program is same in production and development but its giving a timeout error for a big range in development & working farily quick in Production.

Logical DB is ZDDF which is customized from DDF here FAGLFLEXA is taking maximum time.Though it gives timeout dump in foreground in background works correctly and the values are fine.

[Juwin]

Often production systems have more memory, more processing power etc. Hence, it is normal for a program to run quicker in production system, than in a development system, in such a setup.

Thanks,

Juwin

[GirieshM]

Hi Naveen,

Have you checked with Basis Consultant? What was his/her reply?

With Regards,

Giriesh M

[matt]

Performance is also affected by parameters and database statistics, which is why is relevant.

[RaymondGiuseppi]

Could you execute a SQL trace in both systems, if they select different indexes (display access plan) then that could give you some hints, e.g. some indexes inactive, some statistics not up to date. Else that could be only some sizing problem between server and database (production servers are often much more powerful than those of development, and if database was copied you got same volumn of data with less cpu/memory) In any case it doesn't seem to be an Abap development issue.

Regards,

Raymond