AnsweredAssumed Answered

Search performance and folders

Question asked by Jason Capriotti on Feb 4, 2014
Latest reply on Feb 4, 2014 by Charley Saint

I just spent the last 2 weeks restructuring one of the folders in our vault and its has speed up searching quite a bit. When we first implmented ePDM, we migrated in PDFs of all revisions of all engineering drawings we have, about 100,000 pdfs. Our folder structure was a top level folder called "Drawings(PDFs)" followed by about 10 sub folders starting with the drawing number like 1XXXX, 2XXXX, 3XXXX, etc. Then under those, a sub folder was created for each drawing number which contained a PDF for each drawing revision. This entired structure totally about 50,000 subfolders. Searching for a particular drawing usually took around 10 seconds for the search to complete.


I decided to restructure the folders to remove the individual sub folders for each drawing number and created subfolders like:












Ultimately we ended up with about 150 subfolders instead of the 50,000 subfolders.


Search times dropped in half.....about 4-5 seconds instead of 10 depending on the search criteria. We are still on 2012 but testing on 2014 showed it even faster shaving off another second or two.


So having a large number fo sub-folders may neagatively affect your searches.....just something to watch out for. I think the reason for this is in an explanation I received from SolidWorks about why the PDM search wasn't as fast as a query I had written. The search tool considers file, folder, and state permisions for the logged in user to determine whether to display it. I think those 50,000 folders was burdening the search.