
Hi Team,
We have created on WCF service which create and updates data in to CRM. Before update data we need to fetch some details from CRM then update
Target custom entity have approx 25 lakhs data. So Please suggest way to search data in fast manner.
I am using MS CRM 2016.
Thanks
Abhishek
*This post is locked for comments
I have the same question (0)Hi Abhishek,
There isn't any specials way to retrieve the huge data separately. You just need to follow the best practices such as retrieve only if required, retrieve only columns which you are actually using etc. If you are updating the same entity then you can use upsert if it fits your requirement.
msdn.microsoft.com/.../gg509027.aspx
Also take a look on this blog as well- community.dynamics.com/.../retrievemultiple-performance-on-large-datasets
Hope this helps.