SharePoint Document Library speed?

%3CLINGO-SUB%20id%3D%22lingo-sub-1494283%22%20slang%3D%22en-US%22%3ESharePoint%20Document%20Library%20speed%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494283%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20wondering%20if%20having%20a%20larger%20SharePoint%20document%20library%20can%20result%20in%20slower%20access.%20I%20am%20aware%20of%20the%205000%20item%20list%20restriction%2C%20and%20it%20will%20not%20apply%20to%20our%20scenario%20as%20all%20files%20will%20be%20in%20various%20folders%2Fsub-folders.%20So%20my%20question%20is%3A%20Would%20a%20SharePoint%20document%20library%20with%20~120k%20files%20load%2Fsearch%2Fetc.%20any%20faster%20than%20one%20with%20say%20~600k%20files%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1494283%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1495392%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Document%20Library%20speed%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1495392%22%20slang%3D%22en-US%22%3E%3CP%3EAnyone%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1495565%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Document%20Library%20speed%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1495565%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F712355%22%20target%3D%22_blank%22%3E%40Ahmad123%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20never%20worked%20with%20such%20a%20huge%20single%20library.%20For%20all%20my%20projects%20I%20used%20retention%20policies%20and%20automation%20to%20keep%20documents%20and%20records%20ordered.%20Anyway%2C%20the%20Library's%20perfromance%20depends%20on%20many%20parameters%2C%20such%20as%20configured%20indexing%2C%20views%20configuration%2C%20number%20of%20items%20per%20view%20%2F%20per%20library%2C%20etc.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fmanage-large-lists-and-libraries-in-sharepoint-b8588dae-9387-48c2-9248-c24122f07c59%3Fredirectsourcepath%3D%25252fen-gb%25252farticle%25252fmanage-large-lists-and-libraries-in-office-365-b4038448-ec0e-49b7-b853-679d3d8fb784%26amp%3Bomkt%3Den-us%26amp%3Bui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHere%3C%2FA%3E%2C%20you%20may%20find%20some%20clues%20about%20configuring%20large%20libraries.%3C%2FP%3E%3CP%3ETheoretically%2C%20the%20difference%20between%20120K%20and%20600K%20items%20per%20library%20in%20terms%20of%20performance%20could%20be%20noticeable.%20I%20afraid%2C%20it's%20inevitable.%3C%2FP%3E%3CP%3EHowever%2C%20you%20may%20improve%20the%20performance%20with%20better%20views%20configuration%2C%20indexing%20and%20automation%20to%20keep%20the%20number%20of%20items%20per%20library%20reasonable%20(if%20applicable).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20of%20luck!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1496181%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Document%20Library%20speed%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1496181%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F663983%22%20target%3D%22_blank%22%3E%40olegmelnikov%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20will%20look%20into%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1497816%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Document%20Library%20speed%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497816%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F712355%22%20target%3D%22_blank%22%3E%40Ahmad123%3C%2FA%3E%26nbsp%3Bplease%2C%20let%20me%20know%2C%20how%20it%20works%20for%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

 

I am wondering if having a larger SharePoint document library can result in slower access. I am aware of the 5000 item list restriction, and it will not apply to our scenario as all files will be in various folders/sub-folders. So my question is: Would a SharePoint document library with ~120k files load/search/etc. any faster than one with say ~600k files?

 

Thanks!

 

 

4 Replies
Highlighted

Anyone?

Highlighted

Hi @Ahmad123,

 

I have never worked with such a huge single library. For all my projects I used retention policies and automation to keep documents and records ordered. Anyway, the Library's perfromance depends on many parameters, such as configured indexing, views configuration, number of items per view / per library, etc.

Here, you may find some clues about configuring large libraries.

Theoretically, the difference between 120K and 600K items per library in terms of performance could be noticeable. I afraid, it's inevitable.

However, you may improve the performance with better views configuration, indexing and automation to keep the number of items per library reasonable (if applicable).

 

Best of luck!

Highlighted

Thanks @olegmelnikov,

 

I will look into that.

Highlighted

@Ahmad123 please, let me know, how it works for you.