Skip to Content
avatar image
Former Member

Performance improvement of report

Hi All,

We have a zee program which is usually runs in background. The program finds the open sales order. it usually takes around 480 seconds to execute and client want the execution time to be reduced. I have check it in st12 from my end.

St12 shows maximum time cunsumption under ABAP head, the database and the system heads are pretty ok.

Could you please let me know if it is possible to reduce ABAP time? PFB the screenshot.

abap.png

abap.png (111.5 kB)
Add comment
10|10000 characters needed characters exceeded

Further commenting has been locked.
  • Get RSS Feed

3 Answers

  • Jun 09, 2017 at 09:04 AM

    Seems you cannot do many things with this information, 99% of the time consumption is transfer of data between screen (or emulation of screnn in background?) and program. Which tool create the output: alv, html, spool. Could you post the analyzis in the original sort order. What are the statements executed before/after the 99% screen data exchange?

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 08, 2017 at 10:38 AM

    Makrand,

    ST12 also gives us the detailed view regarding the flow of processing logic step by step along with the runtime.

    Going by that you have to identify which part of processing logic is consuming more time and then analyse on the options of optimising the performance of that part.

    K.Kiran.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 08, 2017 at 07:13 PM
    -4

    You need to execute your program in debug mode and do F5 for every step and figure out which statement is taking the maximum time.

    Check for For All Entries without initial check and without DELETE ADJACENT Duplicates. And READ statement without SORT and BINARY.

    Narrow down which statement which is the bottle neck and update us.

    Raju

    Add comment
    10|10000 characters needed characters exceeded

    • The reason I did not reply to the question is because a) I did not feel the need to duplicate the good advice that had already been provided by others, and b) the OP didn't seem very responsive or engaging in his own topic.

      I apologise if you found sarcasm offensive, I shall be more direct in future. Sometimes advice, even if well-meant, can make matters worse, and I believe refuting such statements can be of benefit then I will do so. Your initial advice "You need to execute your program in debug mode and do F5 for every step and figure out which statement is taking the maximum time." is off the mark for a performance investigation. Why should he spend hours debugging if he can get a much better picture in minutes by following Kiran's and Raymond's suggestions? Therefore my intention was to direct the OP towards the other responses. Debugging is not the way to tackle a performance issue until it has been properly investigated with the available tools.

    Further commenting has been locked.