topic Re: Performance Issue with Export to Database INDX in Application Development and Automation Discussions

Performance Issue with Export to Database INDX

Former Member — Wed, 23 Apr 2014 21:18:23 GMT

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.

Re: Performance Issue with Export to Database INDX

custodio_deoliveira — Thu, 24 Apr 2014 01:01:08 GMT

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

Re: Performance Issue with Export to Database INDX

Mohamed_Mukhtar — Thu, 24 Apr 2014 02:07:58 GMT

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

Re: Performance Issue with Export to Database INDX

Former Member — Thu, 24 Apr 2014 04:08:14 GMT

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

Re: Performance Issue with Export to Database INDX

Former Member — Thu, 24 Apr 2014 09:05:04 GMT

Hi Subhajit,

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

Regards,

Sudeesh Soni