Hi,
Our production app is calling the Dynamics API to query for contacts, but we are noticing it is very slow, taking around 13-15 seconds to respond. We are querying for contacts that match an email address or name.
Here is a sample query:
https://{subdomain}.crm.dynamics.com/api/data/v9.2/contacts?$top=25&$filter=(contains(fullname,'test')%20or%20contains(emailaddress1,'test'))%20and%20(Microsoft.Dynamics.CRM.NotIn(PropertyName='statecode',PropertyValues=['0','1']))&$select=fullname,firstname,lastname,emailaddress1&$expand=owninguser($select=fullname,windowsliveid)
I've tried reducing limit from 25, but that doesn't seem to make a difference. Is there anything else we can do to optimize the query? What is the expected latency of this API?
