Improve performance issue with custom program

[Former Member]

Hi

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

[RaymondGiuseppi]

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

[Former Member]

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

[RaymondGiuseppi]

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

[Former Member]

Thank You Raymond.

Will close the thread once we achieve it.