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

Announcements

No record found.

News and Announcements icon
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)
  • Dip Kanjilal Profile Picture
    Microsoft Employee on at

    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

  • CRMISKEY Profile Picture
    180 on at

    Hello Dip,

    This is for D365 CRM services module.

    thanks!

  • Suggested answer
    Dip Kanjilal Profile Picture
    Microsoft Employee on at

    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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
NeerajPawar Profile Picture

NeerajPawar 31

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 19 Super User 2026 Season 1

#3
11manish Profile Picture

11manish 16

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans