In this post I will give you a few performance tips that may be the water divison between a good and a bad performance. I've recently been on a client where most of development was done without any performance caring, which has degraded CRM performance significantly, I'm pretty sure that many of you are aware of those practices but for those who don't, here it goes.
Well, without further ado, let's get straight to the point.
- The addition of lookup fields and option sets to a Quick Find can slow system performance and should be avoided especially on large datasets
- Too many fields on Quick Find - How much more fields added slower the search will be performed.
- Retrieve all attributes when performing a query against the database - Try to narrow fields searched only for those you are going to use.
- Plugins on update stage should not be triggered for all fields, only those that make sense.
- Plugins on Retrive and RetriveMultiple message may cause significant delay performance
- For each entityreference field you retrieve a join is made, so avoid it when possible.
- How many more linked entities or joins you make, slower your query will be processed, sometimes it' better to split up the query for performance improvement.
There it is, if you have any tip besides those I've described, please fell free to share!
Curiosity: In Dynamics CRM 2015 the image field is not retrieved when using all attributes tag.
Further information at: http://crmtipoftheday.com/2016/05/05/use-all-attributes-and-miss-some-of-the-data/
References: https://www.google.com/url?hl=pt-BR&q=https://mbs.microsoft.com/customersource/Global/CRM/learning/documentation/user-guides/PerformanceOptimizationsCRMOnlineSuccess&source=gmail&ust=1464145030739000&usg=AFQjCNFdcz7mGhcLYAOnYf6DoiDGPQ_6Ug
