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

Notifications

Announcements

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
    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
    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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 24 Super User 2025 Season 2

#2
TAHER Mehdi Profile Picture

TAHER Mehdi 14

#3
Fameeda Yaseen Profile Picture

Fameeda Yaseen 10

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans