topic Re: Insert vs any? in Application Development and Automation Discussions

Insert vs any?

former_member649377 — Mon, 16 Dec 2019 13:37:44 GMT

I have a program which is taking lots of time in executing, when i traced the code it seems like the insert statement is the cause for the extra time taken, the insert statement is used to insert a work area into a ddic table, is there any alternative for insert statement which will take less time.

And what is the difference between append and insert and which one is more efficient.

Re: Insert vs any?

FredericGirod — Mon, 16 Dec 2019 13:55:41 GMT

He asks about transpartent table, not internal table, no ?

Re: Insert vs any?

Sandra_Rossi — Mon, 16 Dec 2019 13:57:17 GMT

Are you talking about an internal table or a database table?

Re: Insert vs any?

Sandra_Rossi — Mon, 16 Dec 2019 14:43:39 GMT

Frederic Girod Thanks! I have a doubt now that you ask (I wasn't sure until I saw "append", but maybe the OP thinks "append" can be used with database tables). Let's wait for OP feedback!

Re: Insert vs any?

former_member649377 — Wed, 18 Dec 2019 12:54:27 GMT

yes i asked for transparent table(ddic table)

Re: Insert vs any?

Sandra_Rossi — Wed, 18 Dec 2019 12:57:06 GMT

As your question is about database tables, APPEND is not relevant.

Re: Insert vs any?

Sandra_Rossi — Wed, 18 Dec 2019 12:58:18 GMT

For information, "DDIC table" may refer to both database tables ("DDIC transparent table") and internal tables ("DDIC table type").

Re: Insert vs any?

Sandra_Rossi — Wed, 18 Dec 2019 13:08:53 GMT

INSERT is the fastest and only way to insert row(s) in a database table.

Re: Insert vs any?

former_member649377 — Wed, 18 Dec 2019 14:32:18 GMT

thankyou so much

Re: Insert vs any?

stanislaslemaire — Wed, 18 Dec 2019 15:12:52 GMT

just to be clear, don't INSERT row by row if several data are to be inserted in DB, but from internal table in a single step...
Not sure in your case...