Performance Issue with Export to Database INDX

[Former Member]

Hi All,

I am facing some performance issue with the below statement

EXPORT li_table FROM li_li_table TO DATABASE indx(dl) ID lv_vbeln.

In our system, multiple jobs are running at the same time and hitting this statement. A trace shows this statement to be doing updation and hence taking longer time.

My query is Ideally this statement should behave like an insert statement to the INDX table. Then should there be any locking issue with multiple jobs. Secondly, does high volume of data not work better with this statement.

[custodio_deoliveira]

Hi,

ID lv_vbeln works as (part of) table key, so if this is already used there will be an update instead of insert.

Cheers,

Custodio

[Mohamed_Mukhtar]

Hello Subhajit,

The DB locks will be created for INDX table. These locks can be checked in DB02 transaction.

Use programs RSBTONEJOB or RSBTONEJOB2 to prevent multiple instances of the same job running .

Thanks

[Former Member]

Hi Subhajit,

Pls delete the data from memory after importing it and recheck the code performance.

Refer below code for deletion.

DELETE from database indx(xy) id 'lv_vbeln.

Regards,

Sudeesh Soni

[Former Member]

Hi Subhajit,

If you got the solution then please mark the correct answer and close the thread.

Regards,

Sudeesh Soni