A few days ago, I got pointed to this question on LinkedIn: https://www.linkedin.com/posts/alexander-drogin-0635422b_hey-business-central-developers-im-looking-activity-7231695259485839362-n670?utm_source=share&utm_medium=member_desktop Or in other words: Is it a good practice to first test of a set is empty, to then get the set of records? I had a few thoughts:First, I was like: duh. Stupid question. 2 SQL roundtrips in stead of 1 …
Tag: Performance
Permanent link to this article: https://www.waldo.be/2024/08/23/isempty-findset-or-just-findset/
Rec.LockTable – Good Practice? Or Bad Practice?
Sometimes, “best practices” turn into “bad practices”. And recently, with one of the best new features of Business Central that just fell in our laps (most users probably won’t realize), one good practice became not just unnecessary .. but even a bad practice. When I asked CentralQ. I got a lot of truth, but also …
Permanent link to this article: https://www.waldo.be/2024/03/28/rec-locktable-good-practice-or-bad-practice/
Setting the Sampling Interval for (in-client) performance profiling Business Central
Here’s a small blogpost about an undocumented, but not uninteresting “feature” (at least not in my book ;-)). Performance Profiling You’re probably very much aware of the Performance Profiler in Business Central: an ability to monitor code execution in terms of “durations” and “hit count”, and having a view on how the code/process performed.As a …
Permanent link to this article: https://www.waldo.be/2022/09/30/setting-the-sampling-interval-for-in-client-performance-profiling-business-central/