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

Notifications

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) / Did anyone face perfor...
Microsoft Dynamics CRM (Archived)

Did anyone face performance issue in using WEB API calls?

(0) ShareShare
ReportReport
Posted on by Yadnyesh Kuvalekar 4,102

Hi,

I have implemented a custom grid on the form and facing performance issue intermittently for first time. Did anyone face such issues?

I am doing only below operations:

Retrieve multiple data 

Delete data

Create data

Also, I faced this issue mostly when I load grid after long time and once done, next time onward it works faster.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Yadnyesh,

    In a Retrieve multiple call, provide only attributes which u require for a grid for "ColumnSet" property in array format.

    Also, if you are using pagination for your grid... then use below option as well

    -> While retrieving the data from CRM, provide "Page count" and "Page Number" properties for your query.

    These two changes will have a major impact for performance.

    For Delete and Create try to provide some more filter conditions with unique values so that performance will be more faster than expected.

    PS: Please mark as answer if this is helpful

  • Yadnyesh Kuvalekar Profile Picture
    Yadnyesh Kuvalekar 4,102 on at

    Thanks for the quick response Mani. I am already fetching only required columns and also deleting individual record. I have faced this problem when I use this functionality after long time. After that it loads faster on any machine.

    Is there any caching / warm up issue in using CRM Web APIs?

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    No. There is no issue with Warm up. But when we do a request to CRM and if we dont provide any pagination info (as i mentioned in my earlier response) for the request, CRM will try to load the complete set with max limit of 5000(default). and later requests will work fast as it will just try to update the data in cache (API Cache which is not stored in client machine) if any update happened on the database.

    However, you can try with pagination which helps u with performance. Also, the first request might get delay if the bandwidth is low (between App server to Database server) or (client machine to App)

    You can troubleshoot with checking on any of these.

    PS. Hope, you are using XRM dlls to perform all operations with CRM, if not then instead of Webservice, use Microsoft.XRM.sdk.dll.

  • Yadnyesh Kuvalekar Profile Picture
    Yadnyesh Kuvalekar 4,102 on at

    Hi, I am using CRM Web API in web resources using JavaScript calls. So no DLL is needed as we are still inside CRM. I investigated the issue and observed that due to asynchronous calls I was facing issues. I updated code to make synchronous calls and it resolved the issue. Thank you all for your suggestions. Appreciate it.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans