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

8
  • How many columns the lists have? Commented Aug 25, 2015 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? Commented Aug 25, 2015 at 14:49
  • how many of them are lookup fields?
    – Gwny
    Commented Aug 25, 2015 at 15:26
  • Only 2, and 8 of them Person Or Group if you consider it as Lookup... Commented Aug 25, 2015 at 15:37
  • Check fiddler to see the details of the rest query and to debug what is taking time.
    – Akhoy
    Commented Aug 25, 2015 at 15:56

1 Answer 1

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..

4
  • 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. Commented Aug 27, 2015 at 15:25
  • And it started to happen again:(.... annoying... it is slow again... Commented Aug 28, 2015 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. Commented Mar 2, 2017 at 21:29
  • And my list has only 107 items in it... Commented Mar 2, 2017 at 21:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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