Sharepoint document library over 100k files
We use SharePoint Online (microsoft 365) as a file storage solution leveraging metadata, we anticipate managing over 100,000 files within a single library. Our approach involves employing various metadata fields to facilitate document retrieval, including document type, company, date, among others. We intend to index multiple columns to optimize search performance. However, there are some key considerations we’ve learned from our research on web:
Indexing Limitations: once you cross 5k
Inheritance Restrictions: Once the file count exceeds 100,000, breaking inheritance becomes unable.
Given these constraints, we seek insights from those experienced with managing large file volumes. Have you encountered challenges with search, sorting, or filtering? What strategies do you recommend for efficient document retrieval?
Furthermore, we’ve installed PnP Modern Search and plan to leverage its capabilities for enhanced search functionality. Any advice or best practices regarding its implementation would be greatly appreciated.
Thank you for your insights and guidance.
We use SharePoint Online (microsoft 365) as a file storage solution leveraging metadata, we anticipate managing over 100,000 files within a single library. Our approach involves employing various metadata fields to facilitate document retrieval, including document type, company, date, among others. We intend to index multiple columns to optimize search performance. However, there are some key considerations we’ve learned from our research on web:Indexing Limitations: once you cross 5kInheritance Restrictions: Once the file count exceeds 100,000, breaking inheritance becomes unable.Given these constraints, we seek insights from those experienced with managing large file volumes. Have you encountered challenges with search, sorting, or filtering? What strategies do you recommend for efficient document retrieval? Furthermore, we’ve installed PnP Modern Search and plan to leverage its capabilities for enhanced search functionality. Any advice or best practices regarding its implementation would be greatly appreciated. Thank you for your insights and guidance. Read More