Your code might be too complex and it’s slowing you down.Lets talk about cyclomatic complexity. Sounds fancy, but it’s really just how many decision points are in your functions. The problemTime lost is the cost of complexity as bugs fixes takes longer, adding features delays and new team member gets lost for days trying to…
Read articleBlog
Microsoft Dynamics 365 Business Central
The ProblemYou’ve optimized your code, trimmed every loop, and tuned your queries but performance still drags. Why? Hidden event subscribers might be firing behind the scenes on every database operation, quietly stacking up execution time and slowing everything down.The Fix🔧Keep subscribers leaned and focused – The leaner the codeunit, the faster the execution. That’s why…
Read articleOver the past month, we have covered performance optimization techniques. Today, let’s see how they work together to transform daily operations.Performance stack🔹Dictionary and lists for caching🔹Dictionary for eliminating redundant database calls🔹SetLoadFields for targeted data retrieval.🔹FindSet pattern for efficient record IterationThis set of patterns is great for process improvement. Imagine running a supermarket.✅ SetLoadFields — Instead…
Read articleContinuing our AL performance series (we’ve covered Dictionary caching and SetLoadFields), today I want to spotlight a common pitfall I see in almost every code review: inefficient record iteration.The ProblemProcessing more than 8,000 records. Developers tend to use Find(‘-‘) with repeat-until Next() = 0. Takes a longer processing time. Users complaining, timeout errors in production.Root…
Read articleEver wondered why your code works perfectly in test but crawls in production?. The ProblemA customer creation routine was fast with 50 records but ground to a halt with 5,000+ customers. Classic performance degradation that only shows up at scale.Root Cause DiscoveryUsed the AL Profiler and found the culprit: repeated queries inside loops checking if…
Read articleIf you’ve ever found yourself stuck in painfully slow loops while processing thousands of records in Business Central, this one’s for you. Any routine that might be dragging through 10,000+ records, switching to Dictionary for caching turns out to be a game-changer.The ProblemProcessing 10,000 sales lines that need customer data. Traditional approach hits the database…
Read articleJust wrapped up a major optimization in a journal creation procedure that was crawling through thousands of records. After refactoring with smarter data structures, we slashed processing time by over 80%. The Problem10,000+ records.Repeated DB hits for journal creation and amount calculations.Nested loops causing timeouts and frustration. The Fix✅ Dictionary data type for CachingPre-load invoice…
Read articleEvery Thursday, I’ll share quick coding tips, examples, and shortcuts to help you write better AL code for Business Central. Perfect for beginners and experienced developers alike. Follow #TipsAndTricksThursday and share your own tips too
Read article