Forum Discussion
SharePoint online: index column 5,000 limit
Dear all,
Im working in a Sharepoint online document library with 20k + documents.
I would like to index one of the columns(creation date) in the library, but I am getting the 5,000 limit prompt.
I have read somewhere there is a daily time window where I could make large requests and therefore index the column.
Is this available in SP online? or is there a default time for the window?
Cheers
AFAIK, with SP Online, you don't have access to this. Once you cross 5,000 (they may have been increased to 10,000 for admins or something like that recently), you are pretty much out of luck.
Some quick options I have used in the past or are available in no particular order:
Option 1: Create a new Document Library, with the same content types, columns, etc, and set up your indexes. Create a script (e.g. PowerShell) to "MOVE", not "COPY" the files from Library 1 to Library 2. Not terribly difficult, but does require some coding knowledge.
Option 2 (will make you hold your breath, but it works): Delete ALL of the items in the library (send them to the recycle bin). Then you can turn on the Indexes, and then restore the deleted items from the recycle bin.
Option 3: Third party tools.
9 Replies
In addition to what has been mentioned, you could create an Information Policy that for example, moves items to another location after a certain age
- @Brent nice tips :-)!
Thanks to all for the great suggestions.
I can see now that better planning was needed from my end to index the columns before the migration of documents.
Brent Ellis I think I might go for option 2 as you mentioned.
Ian Moran Good point!
Cheers
- Brent Ellis option 2 is crazy! I like it!
:smileyvery-happy:
I tested like crazy before trying it in the document library, had about 50,000 docs in various folders, but it was a necessary evil and it worked flawlessly.
In my experience, this is no longer an issue, MS is automatically adding indexes to lists when they reach a few thousand items. see https://support.office.com/en-us/article/Manage-large-lists-and-libraries-in-Office-365-b4038448-ec0e-49b7-b853-679d3d8fb784
AFAIK, with SP Online, you don't have access to this. Once you cross 5,000 (they may have been increased to 10,000 for admins or something like that recently), you are pretty much out of luck.
Some quick options I have used in the past or are available in no particular order:
Option 1: Create a new Document Library, with the same content types, columns, etc, and set up your indexes. Create a script (e.g. PowerShell) to "MOVE", not "COPY" the files from Library 1 to Library 2. Not terribly difficult, but does require some coding knowledge.
Option 2 (will make you hold your breath, but it works): Delete ALL of the items in the library (send them to the recycle bin). Then you can turn on the Indexes, and then restore the deleted items from the recycle bin.
Option 3: Third party tools.
