Insert vs any?

[former_member649377]

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.

[FredericGirod]

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

[Sandra_Rossi]

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

[Sandra_Rossi]

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!

[former_member649377]

yes i asked for transparent table(ddic table)

[Sandra_Rossi]

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

[Sandra_Rossi]

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

[Sandra_Rossi]

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

[former_member649377]

thankyou so much

[stanislaslemaire]

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...