web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Suggested answer

Bulk delete nightly - performance

(0) ShareShare
ReportReport
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! 

I have the same question (0)
  • Suggested answer
    Dip Kanjilal Profile Picture
    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
    180 on at
    RE: Bulk delete nightly - performance

    Hello Dip,

    This is for D365 CRM services module.

    thanks!

  • Dip Kanjilal Profile Picture
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 100 Super User 2025 Season 2

#2
Suresh Kulla Profile Picture

Suresh Kulla 72 Super User 2025 Season 2

#3
DAnny3211 Profile Picture

DAnny3211 54

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans