12-16-2019 1:37 PM
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.
12-16-2019 1:55 PM
12-16-2019 1:57 PM
12-16-2019 2:43 PM
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!
12-18-2019 12:54 PM
12-18-2019 12:57 PM
As your question is about database tables, APPEND is not relevant.
12-18-2019 12:58 PM
For information, "DDIC table" may refer to both database tables ("DDIC transparent table") and internal tables ("DDIC table type").
12-18-2019 1:08 PM
INSERT is the fastest and only way to insert row(s) in a database table.
12-18-2019 2:32 PM
12-18-2019 3:12 PM
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...