Form X takes an average of 35 seconds to load (at the client). I did not develop the form - I suspect it comes from AX2012.
I read the following post which was very helpful: https://community.dynamics.com/ax/f/33/t/87286
Mr Drab's verified answer to the problem is very extensive and a bit over my head. I need a bit more specific answer, if possible. I was wondering if someone could help me with a simpler list of properties/code I can play with to improve the performance of the form.
Some details:
- Form pattern: List Page
- Custom code on form: a single displayOption() method
- Form Data Source Query is specified with a query that has a single datasource (so I don't think the query is necessary? - it seems redundant)
- Table cache lookup: none (I am planning to set it to Found&Empty)
Properties that I am aware of that may have an influence:
- Table indexes
- Form Data Source "Maximum Records to Load" property
Are there other simple-ish "things" (properties/code) I can look at or try to improve the forms performance?
Thanks for reading
Please let me know if I am unclear