Forum Discussion
How to find files over certain limit in SharePoint Library with hundreds of folders
It's not possible to add the file size to the library column as I would have to open every possible folder and our hierarchy is crazy. We are not at our limit, however, I know that many users are up...
Minor addition. The 5000 item limit is not a legacy thing. It is caused by the lock escalation mechanism in SQL server. It is one of the top requests on user voice (https://sharepoint.uservoice.com/forums/329214-sites-and-collaboration/suggestions/8463457-remove-the-list-view-threshold-5000-by-default). It basically it means we have to deal with it. For example, by creating indexes, requesting data in sets, ...
Thanks Paul_HK_de_Jong ,
To me the fact that SharePoint online still uses SQL rather than a no-sql back end is the result of architectural decisions made by the SharePoint team years ago when the product was deployed to on-premise servers. The impact of that decision and it's impact, the 5000 item limit, has been (your link was from 2015) and continues to be (comments on your link from 2021) an issue for users.
I agree with you that this constraint is just something we (the paying customers) have to deal with.