locked
CRM 2015 : Bulk delete taking too much time RRS feed

  • Question

  • Dear all,

    I am having an issue while I am launching a bulk delete on a custom entity.  The total number of records for that entity is 200000.

    And it took 5 hours to just delete 1756 records.

    Is there anything that I am missing?

    Any help / guide would be greatly appreciated.

    Many thanks

    Regards

    vinay

    Tuesday, March 1, 2016 11:53 AM

All replies

  • Hi,

    Are there a lot of child records and a cascading rule that deletes or modifies these too? Do you have any custom code working on delete?

    5h for 1800 records seems a bit on the low side of things IMHO.

    Regards


    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Tuesday, March 1, 2016 12:46 PM
  • Hi,

    There is not any child records or any custom code.

    Is there something do to with asynchronous jobs?

    Regards

    vinay

    Friday, March 4, 2016 6:55 AM
  • Hi,

    It shouldn't really, I'm generally counting one operation per second as a "general rule", preferably it should be faster but if it's very much slower something's wrong.

    If it's possible, you could try to write a program that does deletes and see what sort of performance you get there, use executemultiple to increase throughput.

    Regards


    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Friday, March 4, 2016 7:01 AM
  • Have a similar issue. It's taking too long even with the program. 
    Friday, March 4, 2016 9:13 AM