Our client has a news functionality in our intranet based on the standard blog template in SharePoint 2013. The Posts list contains about 4,600 blog posts and the Comments list contains nearly 6,300 comments.
Client likes to know the best way to configure/design their news functionality for the long term future. So we'd like to know the facts about the 5,000 list (view) threshold and how to best deal with this situation. Is it true that the maintenance on the list and/or views beyond 5,000 items becomes very difficult/slow?
What is the best way(s) to go forward? Client considers several options such as:
Creating a new, extra blog site (not ideal)
Using PowerShell to see if you can add a folder to the list (normally this is possible on a list, but not on the lists in the blog site template) to save items in the folder and avoid the 5,000 threshold. (modifying standard SharePoint is actually a no-go for this client)
Remove items (not preferred either)
Neither of these sounds good.
Would be great to hear your experience and configuration/building recommendations!