Dynamics 365 Business Central: the problem of large data deletion – part 2: AlterKey
The article discusses the need for a TRUNCATE option for large data deletion in Dynamics 365 Business Central SaaS. The author mentions the Database.AlterKey method, which is not usable in a SaaS environment, and suggests using the Table Key module from the System Application. The module provides functionality for disabling and re-enabling table indexes, but it is currently only available for on-premises environments. The author proposes removing the on-premises scope and adding a new method to work with a specific key. This would help improve the performance of massive data deletion in Business Central SaaS.
Article 1m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time