topic Re: Improve performance issue with custom program in Application Development and Automation Discussions

Improve performance issue with custom program

Former Member — Tue, 15 Jul 2014 14:10:15 GMT

We have developed a custom program to set user status on project-WBS automatically(with some preconditions) according to an automatic background job run.This program checks all the existing projects and sets the status once preconditions are fulfilled.We have good number of projects and numerous WBS elements.Reading each line from PROJ tables and the updating status using PRPS takes much time and it affects system performance.

So,kindly let me know how can we improve system performance in this case.

Thank You.

Regards

Saurabh

Re: Improve performance issue with custom program

RaymondGiuseppi — Tue, 15 Jul 2014 14:21:03 GMT

Did you analyze the duration of different steps using a tool like SAT (or old SE30) and a SQL trace using ST05, what did you already try (parallel processing, optimization of SQL requests...) ?

Regards,

Raymond

Re: Improve performance issue with custom program

Former Member — Tue, 15 Jul 2014 14:42:06 GMT

Thanks for quick response Raymond.

Actually, I am functional consultant. I am working on this issue with our ABAPer.

If you can provide me on the ways on how can we improve the performance,I would appreciate it.I would search on those ways and go to ABAPer again.

Please give me some pointers ,I will dig on it and come back with our findings on it.

Thanks for providing above methods to check run time analysis.I need to check on it.

With Regards

Saurabh

Re: Improve performance issue with custom program

RaymondGiuseppi — Tue, 15 Jul 2014 15:12:29 GMT

Also don't hesitate to use the scn search tool on those transactions (SAT, ST05, ST12) there are some documents on those in wiki and blog area.

Regards,

Raymond

Re: Improve performance issue with custom program

Former Member — Tue, 15 Jul 2014 15:21:41 GMT

Thank You Raymond.

Will close the thread once we achieve it.