---

### What

---

The 5,000 items list view threshold is a limit on the number of items displayed in a single SharePoint view. This is NOT a limit on how many total items a list or library can hold.

---

### Why

---

This is a performance restriction. Larger database queries require more resources and more processing. This also results in noticeable delays which could cause the browser to hang.

---

### How

---

The solution? Use indexed columns and tweak the default views. Lists and libraries can have multiple views, and each view can filter the content differently…

e.g., Library settings:

---

e.g., view filters:

---

Note: The threshold item limit value can be adjusted for SharePoint Server, but not SharePoint Online.

---

Conclusion:
No one needs to see 5,000+ items in a single view. Because it can be overwhelming, break it up…

Target has online shopping, but they don’t load their entire inventory on their home page. Instead, their inventory is segmented into categories and sub-categories, then each category can have multiple pages. These pages typically list a few dozen items at a time.

“I’m not saying I’m gonna change the world, but I guarantee that I will spark the brain that will change the world.”

Tupac Shakur

#blacklivesmatter