Applies to Product - Dynamics 365 Business Central
What’s happening?
Experiencing performance issues during data import processes, particularly when importing invoice data, which results in significant delays. Additionally, there are concerns regarding rapid database size growth, with reports of 100 GB consumed in a short period.
Reason:
- The performance issues during the invoice import process are suspected to be related to the number of validations and steps executed when creating Purchase Orders and Purchase Invoices.
- The rapid increase in database size may be attributed to the installation of third-party applications that create additional indexes and tables without proper key definitions, leading to inefficient data handling and increased storage requirements.
Resolution:
- For performance issues during data import:
- Consider increasing resources allocated to the Business Central environment to enhance application performance.
- Review the number of records being processed and the validations involved in the import process to identify potential optimizations.
- For database size growth:
- Investigate the installed extensions and customizations to determine if they are contributing to the database size increase.
- Utilize the table information page to identify which tables are consuming the most space and implement strategies to manage their size.
- Ensure that proper keys are defined for new tables and table extensions to optimize performance and reduce unnecessary database growth.
- Monitor the performance of the database and adjust the indexing strategy as needed to maintain efficiency.
- If further assistance is required, consider reaching out to the product team for additional insights and recommendations on managing database performance and size.