Problem list more than 5000 items with column indexed

Question

Hi, I have a list in SharePoint Server 2016 with more than 5000 items. When I use rest only items/&top=20 the rest works fine. But, When I add orderby using a indexed column, like created date, the threshold limit error happen... When I use the column ID in orderby the rest works perfectly. The same behavior happens in native SharePoint view... I have using paging in native view too.

I created the column "created date SP native" like indexed column in library settings.

Thanks

Everton

chriswebbtech · Answer

If your on prem just go in and increase your view threshold? ;)

chriswebbtech · Answer

That said I don’t think SharePoint 2016 has the same tech SharePoint online has for getting around the limit so expanding that is Probabaly  your only option.

everton batista petro alexandre · Answer

ChrisWebbTech&nbsp;&nbsp;Hello Chris, The infrastructure team doesn't increase the limit, because the database would be overloaded... Is there another option?&nbsp;ThanksEverton

everton batista petro alexandre · Answer

ChrisWebbTech&nbsp;&nbsp;When I call in SP 2016 Server:&nbsp;https://homsintegre.ons.org.br/sites/3/41/_api/web/lists/GetByTitle('Produtos')/Items?&amp;top=20&amp;%24select=Id&amp;%24orderby=Created+desc&amp;%24expand=File&nbsp;First the sharepoint get all items and after the sharepoint send the first 20 items???&nbsp;ThanksEverton

chriswebbtech · Answer

Unless you have insane hits on your SharePoint server and a lot of large lists, it will barely touch a modern database server. Those limits are there for high density farms. Not sure on the query, haven't done on-prem in a long while. I just know I just upped my server and had no issues, but my concurrent users wasn't very high.

Forum Discussion

Problem list more than 5000 items with column indexed

5 Replies