Dynamics Community Forum Thread Details

Incidents-RetrieveMultiple/WebApiFetch for one user is slow

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:

Access through Browser to Incident-Views and AdvancedFind of incidents is quick for the user.
The structure of BusinessUnits is very simple (no subordinated BUs).
The user has only two roles which are failry simple. One of them grants full access to Incidents in the same BU and subordinated BUs.
There are no RetrieveMultiple-SdkProcessingSteps.
POA table doesn't contain record for Incidents for specific user (it has only two rows for the user)

Already tried:

adding some new rolle to the user in Order to have eventally used Security-Cacheing/POA recalculated.
Adding sysadmin role helps, but this is not what I want.
updating RecentlyViewedXml field in the UserEntityUISettingsBase (Update UserEntityUISettingsBase set RecentlyViewedXml = null where ownerid ='xxx' and objecttypecode =112) and deleting the record in the UserEntityUISettingsBase. But it didn't help.

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics