Web Api with fetchxml question

(0) Share

Report

Posted on by Balasaheb

680

Hi,

We have used web api with fetchxml to retrieve 50K records and it took around 3 minutes to fetch all records. Is there any way to reduce retrival time to 1 minutes. Can anyone have any idea on this.

Thanks!

*This post is locked for comments

All responses (3)

Answers (0)

BadrinathB 970 on at

Like (0)

Report

RE: Web Api with fetchxml question

Hi Balasaheb,

Go through the below link. Hope this will help you.

dynamicscrmcoe.com/how-do-i-get-de-dynamics-crm
Suggested answer

ashlega 34,475 on at

Like (0)

Report

RE: Web Api with fetchxml question

Hi Balasaheb,

that's a lot of records, so I would not expect this fetch to be very fast(it's not SQL.. keep in mind it's going through the web service).

See if reducing the number of attributes in the fetchXml would help speed up the retrieval..
Community Member Microsoft Employee on at

Like (0)

Report

RE: Web Api with fetchxml question

Hi there, we've been looking for the same solution. Our retrieval time took approx. 5 minutes to fetch 60K records. Let me know if you find the solution to this. Thanks!