Hello,
we are using CRM 2016/365 OnPrem. RetrieveMultiple for specific user of incidents via SDK or via WebAPI is very slow. E.g.15- 25 seconds. The same for other entities for the same user or for incidents with other user credentials ist much quicker . It takes 1-2 seconds.
Access is made via WebApi (https:/servername/orgname/api/data/v8.2/incidents?$top=11 )or via small code sample:
var req = new QueryExpression("incident");
req.ColumnSet = new ColumnSet(true);
req.TopCount = new Random().Next(5, 100);
var time1 = DateTime.Now;
var ec = client.RetrieveMultiple(req);
var duration = DateTime.Now - time1;
(Randomisation is adder to the code sample because without randomization it runs quickly - probably because of cacheing, but that is not what I need. Also it runns quick when the "top" parameter in the WebAPI url is not changed for every query.)
About my system:
Already tried:
Well it looks like fetching all columns makes Retrieve so slow. Incident has like 400 attributes, 70 lookups. When all fetched - it takes 15-25 seconds. Wenn only 10-20 it is very fast.
André Arnaud de Cal...
292,162
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156