A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
SharePoint lists and libraries can store up to 30 million items, but problems usually start much earlier at the List View Threshold (LVT).
The key point is:
- Around 5,000 items in a view or query is where list views and certain operations can start failing or slowing down.
- If a view shows more than 5,000 items, SharePoint can return a list view threshold error.
- This is not a hard storage limit for the list itself. It is a limit on how many items a database operation or query can process at one time.
Why this happens:
- SharePoint stores list data in SQL Server tables.
- When a read or write operation locks more than about 5,000 rows at once, SQL Server may lock the whole table temporarily, which can hurt performance for everyone.
- The threshold exists to protect overall system performance.
What this means in practice:
- A list can grow very large, even into the millions of items.
- Performance issues usually show up when:
- a view returns too many items,
- filtering or sorting is not selective enough,
- operations try to process all items at once.
- Filtered views on large lists can still work well if they return a smaller subset of items.
- Microsoft recommends using the modern experience for views that show many items, because it handles large lists better than the classic experience.
Other relevant limits:
- Maximum items in a list or library: 30 million
- Maximum individual file or attachment size: 10 GB
So, the practical answer is:
- The list itself does not usually become a problem at 5,000 total records.
- Views, queries, and operations become the problem when they need to work with more than about 5,000 items at once.