topic Re: Performance Improvement in Application Development and Automation Discussions

Performance Improvement

Former Member — Tue, 15 May 2007 08:37:41 GMT

When we split the single internal table into multiple table and processing each table seperately, how improves the performance?In what way the performance is getting improved by this?How to debugg and see the different internal table content in this case.

Re: Performance Improvement

Peter_Inotai — Tue, 15 May 2007 08:41:03 GMT

I don't thing it will improve performance a lot. You better focus on database access (SELECT, UPDATE, etc), normally this is the area where the most improvements can be done.

Splitting internal table actually only helps to avoid memory overflow.

>How to debugg and see the different internal table content in this case.

Put the name of the splitted tables in the debugger to see the content.

Peter

Re: Performance Improvement

Former Member — Tue, 15 May 2007 08:42:04 GMT

Hi Shri Ram,

Splitting an internal table will be of help when the program goes for dump...as mentioned in the prev queston u posted.

spilt the internal table for different conditon, if any, for the processing.

select only the required records for the processing from the Internal table. this mite reduce the load on the server.

move the records to diff internal tables by specifying required conditions.

it does improve performance.this will avoid unnecessary processing of all records.

check for data population into the internal table. chk if you can restrict the entries and move into different internal tables, if possible.

regards,

madhu

Re: Performance Improvement

Former Member — Tue, 15 May 2007 08:47:27 GMT

Hi,

Try to use field symbol: and refer my post in your other thread.

REPORT demo_int_tables_read_assigning .

DATA: BEGIN OF line,
        col1 TYPE i,
        col2 TYPE i,
      END OF line.

DATA itab LIKE HASHED TABLE OF line WITH UNIQUE KEY col1.

FIELD-SYMBOLS <fs> LIKE LINE OF itab.

DO 4 TIMES.
  line-col1 = sy-index.
  line-col2 = sy-index ** 2.
  INSERT line INTO TABLE itab.
ENDDO.

READ TABLE itab WITH TABLE KEY col1 = 2 ASSIGNING <fs>.

<fs>-col2 = 100.

LOOP AT itab INTO line.
  WRITE: / line-col1, line-col2.
ENDLOOP.

Jogdand M B

Re: Performance Improvement

harishaginati — Tue, 15 May 2007 08:48:16 GMT

hi Buddy..,

performance can never be improved by splitting and processing internal tables..,

normally what happens is when you run a report this report will be executed in 1 available work processor..,

but we can run same report in multiple work-processors by splitting internal table into 2/3 parts and process each processing logic in different work processors which would decrease in execution time..

for this search SDN network with term 'Parallel processing'..., this could solve your problem..

<b>

reward me points if useful and close thread..,</b>

cheers,

Harish

performance can be improved certainly improve...,