Forum Discussion
Solved
Sincerely requesting advice! How many rows can a list in SharePoint hold?
How many lists can be stored in SharePoint and how many rows of data can be stored in each list? I've found some information about this in the documentation, but I'm not quite sure if it's correc...
- 5000 items is the view limit, any more and you start getting issues with filtering(filter doesn't show all items), slow down, problems with querying. Reason for this is that it becomes to much for the back-end to manage in the view.
The more item you have the larger the issue becomes, at 100K you lose the ability to have custom permissions etc.
If you don't care about any of these issues you can have 30 million items...
Also having that much item won't be managable...
That is correct but It's not recommended to have over 5000 items. You start having some weird behaviour in filtering and sorting and just managing the list.