Skip to Content

performance tuning

Please use more informative subject in future

IF NOT l_lock IS INITIAL.
  UPDATE marc FROM TABLE lt_marc.
  IF sy-subrc = 0.
* creation of change document - ZZACT
    PERFORM cd_call_mat_full.
    COMMIT WORK.
  ELSE.
    ROLLBACK WORK.
    CLEAR gt_return.
    gt_return-type = 'E'.
    gt_return-message = 'Problem with update entries in MARC !'(011).
    PERFORM log_message TABLES gt_mess_list
           USING gt_return gt_todo_list.
  ENDIF.

How can we improve the performance of program?? Any other better query which will replace UPDATE statement???

Edited by: Matt on Mar 26, 2009 9:54 AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 26, 2009 at 06:31 AM

    Hi,

    if you are changing the MARC(standard table )....use the FMs instead of the MODIFY or update.

    tyr to look with the FM CM_FV_MARC_UPDATE

    or else try with

    MODIFY marc FROM TABLE lt_marc.

    Thanks!

    Edited by: Prasanth on Mar 26, 2009 12:02 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 26, 2009 at 06:32 AM

    HI,

    Try to use modify statement instead of update.

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 26, 2009 at 06:50 AM

    First of all NEVER EVER update these standard tables yourself (See comment Prashant). So change that first and use the proper function modules (BAPI's) for this. Then, and only then see how to improve performance, if still necessary.

    Edited by: Micky Oestreich on Mar 26, 2009 7:50 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 26, 2009 at 07:26 AM

    Hi,

    Do not commit work, the LUW will automatically commited at the run time. Use Commit only if you are reusing the table later in your program.

    Regards,

    Prashant.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 26, 2009 at 08:56 AM

    Please use more informative subject in future

    And don't update SAP tables directly. It's a good way of of invalidating your support agreement with SAP.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.