Skip to Content
author's profile photo
Former Member

Performance Issue

HI,

When I am copying the entries from one table to another table and using modifying statement,

it is taking a lot of time during execution.

the number of entries in the first table are some 20,000 records

my logic is:

1)selecting the records from the first table into an internal table

2)loop and the modify the second table.

the performance is too slow.

is there any way where i can increase the performance.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Oct 06, 2005 at 04:31 PM

    Hi

    Are you using select - endslect. Modifying in Loop.

    Why not use SELECT INTO TABLE ITAB.

    ( itab has structire of your first database table )

    Populate entries from ITAB to ITAB1.

    ( Itab1 has structure of you second database table

    For modify you can use

    MODIFY <DBTAB> from TABLE ITAB1.

    Cheers

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Srinivas Adavi

      Hi Guys,

      Thanks for the answers. The problem is solved now. I did not use any loop.

      I did award the points.

      Thank You very much for all of those who participated in this thread.

  • author's profile photo
    Former Member
    Oct 06, 2005 at 04:30 PM

    Use field symbols. It can improve the performance.

    Add comment
    10|10000 characters needed characters exceeded