1
J

Make all-company BYOD export one truly all-company export

Joost Bromelow on 10/21/2021 7:44:27 AM
All-company BYOD export generates sequential exports, company after company. Since 10.0.16 these jobs no longer run in parallel to avoid locks. Downside is that these exports take a lot longer.

Suggestion is to change the all-company export into one truly all-company export; fully independent from selected company. Not anymore to export company by company.

This should deliver significant performance improvements.
Category: Data Management
STATUS DETAILS
Declined
Ideas Administrator

Administrator on 10/25/2021 4:55:32 PM

Concurrent exports for the same entity to the BOYD database may cause high DTU usage and can result in data loss for incremental exports. To avoid this risk, starting in version 10.0.16, all execution across companies will be sequential per company. This means that jobs with a high number of entities and companies take longer to run.

To reduce the overall export times, consider the following:

  • Make sure that the same data entity is not in multiple projects so that the projects can run without conflicting with each other.
  • Put entities that take a long time to run in separate projects. This will allow the other projects to run faster.
  • Use Full push only exports instead of Incremental only exports for smaller data sizes. For example, you may want to do this if some of the entities have record counts of around 1,000 or less.
  • Create cross-company entities if you do not need to export data per company, individually.

Bring your own database (BYOD) - Finance & Operations | Dynamics 365 | Microsoft Docs