In our company we recently moved to SharePoint 2013 Foundation version (on premise)
Now I have few list libraries which have move than 5000 record items on different sub sites. Currently the highest library have 45000.
Now I am unable to view them or select the custom views that we created to filter / group the list. After reading some blogs I changed the limit to 50000 in the central administration. Then everything works fine. However as recemommed by many users if this limit is increased in central administration it can slow down the Sharepoint performance. So I had to reset it back to default 500
Please could some guide me in step by step what is the work around for this or how can I resolve this.