Factors causing lag in Microsoft Business Central [Navision]
The main factors causing lag in Microsoft Business Central (formerly Navision) include the use of SharePoint or Excel as a data source, which introduces latency due to constant file access, read/write locks, and the lack of efficient indexing. Any direct integration via OData or connectors can significantly slow down operations. Poorly designed workflows also contribute to performance issues. Workflows that include unnecessary API calls or excessive table queries create bottlenecks, while those processing large amounts of data without optimization can overload the system. Recursive queries and poor SQL optimization are another major cause. Poorly written AL or C/AL code can generate recursive SQL queries that strain the database server. Additionally, the absence of proper indexing forces the system to read large amounts of data, slowing down operations. Excessive use of poorly optimized plugins and customizations can also degrade performance. Badly designed plugins may introduce inf...
