Skip to main content

Notifications

Service | Customer Service, Contact Center, Fie...
Suggested answer

Bulk delete nightly - performance

Posted on by 180

Hello experts,

i would like to go for an option where i would like to delete around 3000 records from a custom entity, that might grow about 850k records per year. The bulk delete job will run during off business hours, nightly. it has one child entity, that might have 2 or 3 records for each parent record. i would like to know if it would create any performance problem accessing this custom entity in the short or long run. Appreciate your valuable comments. Thanks! 

  • Suggested answer
    Dip Kanjilal Profile Picture
    Dip Kanjilal on at
    RE: Bulk delete nightly - performance

    Thanks for telling that. I am working on AX tech now but I worked on CRM before. According to me, this looks fine and should not cause performance issue as long as you are dealing with less than 1 million records in AsyncOperationBase table and the cleanup job is running during off business hours.

    Let me know if this helps.

    Regards,

    Dip

  • CRMISKEY Profile Picture
    CRMISKEY 180 on at
    RE: Bulk delete nightly - performance

    Hello Dip,

    This is for D365 CRM services module.

    thanks!

  • Dip Kanjilal Profile Picture
    Dip Kanjilal on at
    RE: Bulk delete nightly - performance

    Hello,

    Is this regarding D365 CRM or D365 FnO? The tags are not clear and the problem statement does not mention it as well. If D365 FnO, the answer may also vary upon which Platform Update you are on.

    Regards,

    Dip

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans