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?