I have requirement to upload 30K records every year in document library and further attach workflow and do some stuff based on business criteria.
I need to plan for capacity in SharePoint, so I need to know how many Excel sheets can I store in SharePoint 2013? Also I want to know the best practices to store Excel documents in SharePoint.
Every year if I have 30K files, after 5 years I will have 150000 records in my document library. Will I have a performance hit anytime? If yes, how do ensure I plan it in better way.