1 Reply Latest reply: Jan 20, 2011 8:01 AM by Pankaj Aggarwal RSS

drop insert versus Array delete

Nick Wells
Currently Being Moderated



Which receiver client delete goes faster?  "drop insert" or "Array delete"





  • Re: drop insert versus Array delete
    Pankaj Aggarwal
    Currently Being Moderated

    This depend on the current configuration of your receiver system like -

    > is it a multiclient system or a single client

    > how much data does the current client ( to be deleted) has as compared to other clients.

    > is the current client already (almost) blank


    So based on above the system makes a decision on which method would be best and the decision so taken is the most optimum and should not be changed.


    If at all it is required to be changed then the same should be consulted with an expert.

  • Re: drop insert versus Array delete
    Bruno Esperan├ža
    Currently Being Moderated

    Hi Nick!


    Please refer to chapter 5.5 on the SAP TDMS Operations Guide. Drop insert is generally faster but you cannot use it in a multi-client system unless you are able to lock the users in all clients.


    If the receiver system has more than one client and you cannot lock users in other clients than you must choose array-delete, otherwise it is recommended to choose the deletion settings from activity 'Define Deletion Scenario Automatically'.