A quick tip around improving CRM data retrieval performance using fetchxml, this is applicable to both RetrieveMultiple and SSRS performance.
What is no-lock?
Whenever we query CRM using fetchxml,a lock is issued against the table. when we use No-lock the process of issuing lock is skipped. This type of data retrieval is also called as dirty read because there is a chance that you might read the uncommitted data before rollback.
- Improves SSRS report performance or RetrieveMultiple performance on high transaction oriented tables
<fetch mapping="logical" no-lock="true" >
<entity name="account" />