List view threshold is termed as LVT.
SharePoint developer introduced this settings at web application level. In order to avoid the server performance issue. It really matters for server performance if you are about to view 1000 of records on the list. Because all the data is available at content database and view you open the list it fetch the records from the database and display on the list.
If you set 6000 LVT on the web application level then your list will allow to view only 6000 item on the list. On the backend what it does it fetches the 6000 records from the db and display these 6000 records accordingly on the view by setting number of item view on a page.
Its not advisable to increase the LVT by 5000.
How to set LVT:
SharePoint developer introduced this settings at web application level. In order to avoid the server performance issue. It really matters for server performance if you are about to view 1000 of records on the list. Because all the data is available at content database and view you open the list it fetch the records from the database and display on the list.
If you set 6000 LVT on the web application level then your list will allow to view only 6000 item on the list. On the backend what it does it fetches the 6000 records from the db and display these 6000 records accordingly on the view by setting number of item view on a page.
Its not advisable to increase the LVT by 5000.
How to set LVT:
- Go to central administration
- Go to Application Management
- Manage Web Application
- Choose web application
- Under ribbon General Settings => drop down "Resource throttling"
- List view threshold = set limit here(try to keep it less than 5000 if the environment is production else you can keep more).
No comments:
Post a Comment