Sunday, April 2, 2017

SharePoint List and Library limitations

Uncompleted article (bare with me):

SharePoint Online

List view threshold limit in site libraries or lists
5000 max items per view (without index) and 12 lookup columns per view. For more information, see Manage large lists and libraries in Office 365.
5000 max items per view (without index) and 12 lookup columns per view. For more information, see Manage large lists and libraries in Office 365.
Terms in term store
200,000
200,000
Site collection storage limit
Up to 25 TB per site collection.
Up to 25 TB per site collection.
Kiosk workers (plans K1-K2) cannot administer SharePoint site collections. You will need a license for at least one Enterprise plan user to manage Kiosk site collections.
Site collections (#) per tenant
500,000 site collections (other than personal sites).
500,000 site collections.
Subsites
Recommended up to 2,000 subsites per site collection
Recommended up to 2,000 subsites per site collection

To increase the List View Threshold:

You have to change the List View Threshold to the number of items returnd in one database query.
  1. You do that in Centra Administration > Application Management > Manage Web applications. In the ribbon
  2. select the Web application you want to edit
  3. select General Settings
  4. edit List View Threshold item limit.
enter image description here enter image description here

1 comment: