You’re offline. This is a read only version of the page.
245
Is there general guidance on when and when not to set OnlyFetchActive to true? In profiler I can see several queries executing that have 50+ columns, but can't imagine all of them are being used. I remember in the past enabling it for one data source which improved performance quite a bit, thus wondering if I should continue to do this for the many other data sources we have.
*This post is locked for comments
I have the same question (0)
If you look into AX documentation, you'll see that "this property is designed to be used in lookup forms" (source), which is confirmed in Best Practices for Lookup Forms.
The reason why it's not recommended for all forms it that you can easily get into problems when saving records with just some fields fetched (impossible in lookup forms) and with code referring to fields which weren't fetched from DB (such code isn't common in lookup forms).
If you always fetch fields from many datasources, maybe you should redesign your form. Nevertheless 50 columns isn't normally a big deal, if we're not talking about memo fields or such things.
Share
Report
All responses (
Answers (
