1

I have about 10 list in my SharePoint site.

I am using REST to query some data. However, I have got an irritating issue.

I have lists called, Applications(3000 Items), Candidates(30000 Items), Vacancies(2000) items.

When I try to query Applications and Candidates, the query is so quick. However, even though Vacancies list has much less items in it, and I select only 2 fields, it takes about 15 seconds, and my query only returns 260 items.

I am trying to find out why REST query takes longer for a specific list. I dont know where to look at as it is a bot black box for me now.

any idea why this is behaving like this?

thanks

  • How many columns the lists have? – Diego Hillesheim Aug 25 '15 at 14:45
  • Around 40, but not all of them are queried. If you do not specify in the $select part of the REST query, would it still query them? – AnarchistGeek Aug 25 '15 at 14:49
  • how many of them are lookup fields? – Gwny Aug 25 '15 at 15:26
  • Only 2, and 8 of them Person Or Group if you consider it as Lookup... – AnarchistGeek Aug 25 '15 at 15:37
  • Check fiddler to see the details of the rest query and to debug what is taking time. – Akhoy Aug 25 '15 at 15:56
1

Interestingly, this issue has been resolved.

I removed an unused field and it started to perform as is used to perform.

However, I am not sure why deletion of a random file resolved the performance problem. I would love to tell the reason, but I really do not know.

I am also not sure whether my answer is a real answer..

  • This is possible. One of the reasons might be row wrapping. SharePoint stores items from all lists in a single database table. This table has a fixed number of columns for each field type. If you exceed those numbers SharePoint uses 2 rows in DB for each item and must JOIN them. Removing one field may do the difference here. – dstarkowski Aug 27 '15 at 15:25
  • And it started to happen again:(.... annoying... it is slow again... – AnarchistGeek Aug 28 '15 at 9:16
  • I'd be interested in knowing if you got any farther on this. I had the same issue, but it was taking 1 min and 30 sec. I removed a field and it was much faster. Please post back if you ended up finding a long-term fix. – Robert Kaucher Mar 2 '17 at 21:29
  • And my list has only 107 items in it... – Robert Kaucher Mar 2 '17 at 21:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.