Forum Discussion

EVERTON BATISTA PETRO ALEXANDRE's avatar
EVERTON BATISTA PETRO ALEXANDRE
Brass Contributor
Apr 03, 2019

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...
2016
sharepoint server
ChrisWebbTech's avatar
ChrisWebbTech
MVP
Apr 03, 2019
If your on prem just go in and increase your view threshold? ;)
  • EVERTON BATISTA PETRO ALEXANDRE's avatar
    EVERTON BATISTA PETRO ALEXANDRE
    Brass Contributor
    Apr 03, 2019

    ChrisWebbTech 

     

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

     

    Thanks

    Everton

  • ChrisWebbTech's avatar
    ChrisWebbTech
    MVP
    Apr 03, 2019
    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's avatar
      EVERTON BATISTA PETRO ALEXANDRE
      Brass Contributor
      Apr 03, 2019

      ChrisWebbTech 

       

      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

      • ChrisWebbTech's avatar
        ChrisWebbTech
        MVP
        Apr 03, 2019
        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.