API call to view Site restore session very slow

[martynh]

We are having an issue with one of our customers where exploring their sharepoint backup is extremely slow, folder list takes about 4 minutes to return and documents list 3 minutes.
This has been ongoing for a few months and we have not found a solution despite trying numerous suggestions including upsizing the server. The methods we are using are

https://{{BaseURL}}/v5/RestoreSessions/[restoresessionID]/Organization/Sites/[siteID]/Folders?offset=0&limit=30&parentId=[parentID] (Folders)

https://{{BaseURL}}/v5/RestoreSessions/[restoresessionID]/Organization/Sites/[siteID]/Documents?offset=0&limit=30&parentId=[parentID] (Documents)

This is related to support case #05224414

[nielsengelen]

Hi Martyn,

I can't really see an issue with your query as you only request 30 items. It could be related to undersizing of your appliance but the only way to understand this is via the support case. Please continue working with them.

[martynh]

Hi @nielsengelen
Just to update we have isolated the issue further. The bottleneck in this request is clearly the addition of a "ParentID" parameter to the request for documents. Requesting Documents with no limit and no ParentID parameter took under a minute. Adding a limit=30 didn't affect that time noticeably. Adding a ParentID filter to return just the documents within the specified folder took 4:07 to return a single document.

[Mike Resseler]

@martynh At this point in time we are in release mode so I'm afraid I cannot ask our QA to do some more investigation on it why that single document takes that long. I have an idea but it needs to be verified. However, since we do have a case, I will put this on their investigation list for after the release. I hope the case isn't closed yet so we won't loose the logs.

[OzFenric]

Support case #05224414 has been reopened with further investigation carried out.

[Mike Resseler]

Thanks @OzFenric please keep us informed about the outcome