topic Re: Logical database program running slowly in Application Development and Automation Discussions

Logical database program running slowly

former_member282968 — Fri, 12 Jun 2015 11:26:35 GMT

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.

Re: Logical database program running slowly

Former Member — Fri, 12 Jun 2015 11:37:06 GMT

Hi Naveen,

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

Thanks

Vijay SR

Re: Logical database program running slowly

GirieshM — Fri, 12 Jun 2015 12:55:44 GMT

Hi Naveen,

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

WIth Regards,

Giriesh M

Re: Logical database program running slowly

former_member282968 — Fri, 26 Jun 2015 14:15:36 GMT

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.

Re: Logical database program running slowly

Juwin — Fri, 26 Jun 2015 14:48:27 GMT

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

Re: Logical database program running slowly

GirieshM — Wed, 01 Jul 2015 09:23:08 GMT

Hi Naveen,

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

With Regards,

Giriesh M

Re: Logical database program running slowly

matt — Wed, 01 Jul 2015 09:28:43 GMT

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

Re: Logical database program running slowly

RaymondGiuseppi — Wed, 01 Jul 2015 13:50:02 GMT

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