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...
Thanks for your reply.
I got your point, but 5,000 items and 100,000 items are way too much of a difference, isn't it? Why is that?
I got your point, but 5,000 items and 100,000 items are way too much of a difference, isn't it? Why is that?
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...
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...