Forum Discussion
Problem list more than 5000 items with column indexed
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 t...
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.
When I call in SP 2016 Server: https://homsintegre.ons.org.br/sites/3/41/_api/web/lists/GetByTitle('Produtos')/Items?&top=20&%24select=Id&%24orderby=Created+desc&%24expand=File
First the sharepoint get all items and after the sharepoint send the first 20 items???
Thanks
Everton
- 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.