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.


The List View Threshold is by default 5000 items. This limitation is due to the way how SharePoint works, especially related to SQL server queries.

The best way is to separate the library (libraries) (and the content inside) using relevant approach (i.e. alphabetically or by project or any other suitable option) in such way that every library contains < 5000 elements.

Also, consider adding indexes to fields (columns), it may help.

Please also refer to design guidelines\explanations:

Designing large lists and maximizing list performance (SharePoint Server 2010)

Working with Large Lists in SharePoint 2010 – List Throttling

Manage large lists and libraries in SharePoint

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.