Hi experts,
Is there any guidance regarding when to use SysDa vs old Query objects?
Thanks,
Hi experts,
Is there any guidance regarding when to use SysDa vs old Query objects?
Thanks,
Hi Yuji, In case you haven't checked this article.
You can refer Google where you can see many blogs on that.
Comparing both I found SysDa is most faster than normal query classes. This is one of the reason why MS implemented this. Faster in the sense it is similar to the speed of normal select statement. But for extendibility, SysDa is more preferred because, here you can add ranges, do crud operations which cannot be performed in normal query builder classes. So if you need to use query classes then for performance I would suggest you to use SysDa.
The main reason (IMHO) for using SysDa is when you're working on something performance-critical.
On the other hand, it's a low-level API that it cumbersome to write and difficult to read, therefore I use it sparingly.
André Arnaud de Cal...
292,884
Super User 2025 Season 1
Martin Dráb
231,760
Most Valuable Professional
nmaenpaa
101,156
Moderator