topic code optimization Array Insert vs insert from ITAB in Application Development and Automation Discussions

code optimization Array Insert vs insert from ITAB

Former Member — Thu, 24 Jan 2008 20:23:14 GMT

Hi,

I have a general question.

I am doing insert using

Insert into <table> from <Internal-Table>

where <Internal-Table> contains more than hundred record.

Also just for your information. I am doing insertion just one by one. I am doing batch input which means that Internal Table already contains 100 record. I know if I do insert one by one..it will be costly I/O operation. That is the reason, I made sure that my Internal Table contains all the record before I do insert.

My question is, whether my insert statment is optimal way to do insert?

I read somewhere that Array Insert is better.

Could you explain why so.

Re: code optimization Array Insert vs insert from ITAB

Former Member — Thu, 24 Jan 2008 20:41:08 GMT

I think you'll find that an array insert means inserting from an internal table, so you're OK as is.

Rob

Re: code optimization Array Insert vs insert from ITAB

rajasekhar_matukumalli3 — Fri, 25 Jan 2008 00:45:09 GMT

Hi,

If you are insering into a database table, I suggest you to use MODIFY command rather than INSERT to avoid any kind of dumps due to duplicates.

Thanks

Raj