inserting records from internal table to database table

[Former Member]

Hi all,

i want to insert records from internal table to zDatabase table, can u plz guide me which statement is better in performance to insert the records.

1) insert one by one record from internal table

loop at itab.

insert ztable from wa.

endloop.

2) insert total records at a time

INSERT <dbtabname> CLIENT SPECIFIED FROM TABLE itab.

or let me know if any other statement is there with high performance.

i internal table contains nearly 40000 records.

thanks.

[Former Member]

The second one is the best ..

2) insert total records at a time

INSERT <dbtabname> CLIENT SPECIFIED FROM TABLE itab.

[Former Member]

thanks for the reply srinivas.

[Former Member]

Hi,

Insert the entire table at atime rather than a record so as to increase the performance.

you can use INSERT <dbtabname> CLIENT SPECIFIED FROM TABLE itab.

or

MODIFY ZPRODUCT FROM TABLE GI_AFPO.

Regards,

Raj.

[Former Member]

Hi,

The second INSERT statement is better.

regards,

Ramya

[Former Member]

hi,,

go with second one

INSERT <dbtabname> CLIENT SPECIFIED FROM TABLE itab.

regards,

rekha