Forum Discussion

Brass Contributor

Nov 15, 2019

Need some advice on working with a large document library

Hi all we are on SharePoint Online, and want to store an archive with 50000 PDF files in it. The library should be searchable on the document title. I already tried some things but I'm running in...

MVP

Nov 15, 2019

Yeah, not sure why you are creating the other column and populating, the search should pull the file name as is from the name column. I do try to split my documents into sub folders by date as well but the libraries are made to handle 30 million documents, folders are not required.

Andrew Hodges

Bronze Contributor

Nov 15, 2019

Hi ChrisWebbTech ,

I agree folders are not strictly required but if a view or Folder is returning/has more than 5000 items (roughly) the following error is returned -

I haven't see it is possible to just have 50,000 files returned by the default "All documents" view without putting those files in folders or applying meta data to cut down what is returned. I got this error by turning on "Show items without folders" in the view settings.

ChrisWebbTech
MVP
Nov 15, 2019
Hmm, I have a library with well over 5000 items and the no folder view works just fine. I do have a handful of indexes thou. Make sure that view does not have any filters applied.
- Jille Floridor
  Brass Contributor
  Nov 15, 2019
  Hi ChrisWebbTech an Andrew Hodges
  
  Thanks for your replies!
  
  The idea behind the additional columns was to use them for filtering, since search didn't return any results. I didn't mention I'm filling two more columns. I split the filename to fill a name, firstname and a date column.
  
  I'm going to create a set of folders and try and upload the files in those folders. See how that works out.