Forum Discussion
Single Index vs. Secondary Column Index | Index strategy over 5000 items
I have many lists that are migrating breaking the magic 5000 items list view threshold. Fun stuff. I am unable to add indexes to the lists as it says the item limit is to high. Feels like a catc...
My two cents here:
1. Assuming you are talking about SPO, the only alternative I can think to create such indexes is buy using CSOM but you will probably have the same problems.
2. Indexes are good for views, but can penalize the performance when doing CRUD operations
3. You have to view this such as creating indexes in SQL Tables
1. Assuming you are talking about SPO, the only alternative I can think to create such indexes is buy using CSOM but you will probably have the same problems.
2. Indexes are good for views, but can penalize the performance when doing CRUD operations
3. You have to view this such as creating indexes in SQL Tables
As far as I know indexes are the key component for dealing with large lists. Folders are obviously another one. But I didn't get into SPO to use folders (in general) https://support.office.com/en-us/article/Manage-large-lists-and-libraries-in-SharePoint-B8588DAE-9387-48C2-9248-C24122F07C59
I, like everyone in SharePoint land, greatly dislike the fact that a list/library can hold million of items but seems to get "stuck" at 5000.
I am using the indexes as my first step in the guidance for large lists. I am I wrong on that?
Do you have other suggestions for handling large lists?
Is the CRUD issue something you actively architect against? Do you suggest using folders as the only way to utilize a list/library with more than 5000 items? Or do simply not allow for over 5000 items?
I, like everyone in SharePoint land, greatly dislike the fact that a list/library can hold million of items but seems to get "stuck" at 5000.
I am using the indexes as my first step in the guidance for large lists. I am I wrong on that?
Do you have other suggestions for handling large lists?
Is the CRUD issue something you actively architect against? Do you suggest using folders as the only way to utilize a list/library with more than 5000 items? Or do simply not allow for over 5000 items?