web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / FetchXML Performace is...
Microsoft Dynamics CRM (Archived)

FetchXML Performace issue in web template

(0) ShareShare
ReportReport
Posted on by SP211 130

Hi,

We have a web template that contains fetchxml to query CRM but we are experience performance issues and the page can take up to 1 minute to load.  Have looked at the following article - {know-how} MSCRM FetchXML SSRS - Improve performance with No-Lock - FetchXML Nolock which suggests the no-lock attribute but this hasn't helped.  Can anyone suggest any other mechanisms to try and improve the performance.  The fetchxml links to several other entities.

Thanks in advance,

*This post is locked for comments

I have the same question (0)
  • David Jennaway Profile Picture
    David Jennaway 14,065 on at

    If you're using CRM OnPremise, then you may be able to improve the performance by use of SQL indexes. Use SQL Profiler to capture the SQL query submitted by CRM from the fetch, then you can analyse this in SQL Management Studio.

    If you've CRM Online, there's not much that you can do. It may help to use paging if you're not doing so already, so that the first records may be returned more quickly

  • SP211 Profile Picture
    SP211 130 on at

    Thanks for the reply David.  Its D365 so cant do the sql indexes.  We arent using paging so i'll look into this to see what can be achieved.

  • Suggested answer
    Dmytro Rutkovskyi Profile Picture
    Dmytro Rutkovskyi 1,835 on at

    For generic fetchXML performance:
    I suggest using XmlToolBox with FetchXML Builder plugin - it should be mostly the same performance so you can test much quicker.
    Avoid many attributes (like <all-attributes/>), locks, distinct, aggregates where possible. 

    As David Suggested you can use Paging.

    And because your questions are in Portal section, you can use several FetchXML to retrive some other related entities and use it to build more effective resulting fetchxml. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
ScottDurow Profile Picture

ScottDurow 2

#2
GJones Profile Picture

GJones 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans