topic Re: inserting records from internal table to database table in Application Development and Automation Discussions

inserting records from internal table to database table

Former Member — Wed, 23 Apr 2008 11:47:43 GMT

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 — Wed, 23 Apr 2008 11:51:35 GMT

The second one is the best ..

2) insert total records at a time

INSERT <dbtabname> CLIENT SPECIFIED FROM TABLE itab.

Former Member — Wed, 23 Apr 2008 11:52:07 GMT

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.

MODIFY ZPRODUCT FROM TABLE GI_AFPO.

Regards,

Raj.

Former Member — Wed, 23 Apr 2008 11:53:13 GMT

Hi,

The second INSERT statement is better.

regards,

Ramya

Former Member — Wed, 23 Apr 2008 11:55:03 GMT

thanks for the reply srinivas.

Former Member — Wed, 23 Apr 2008 11:58:41 GMT

hi,,

go with second one

INSERT <dbtabname> CLIENT SPECIFIED FROM TABLE itab.

regards,

rekha