In a previous blog, we provided a query to find folders that had a large file count (>1000 files). Folders of this size can lead to performance issues in SOLIDWORKS EPDM when browsing or referencing files in these folders. It is also possible that folders with a high number of folders can cause performance issues. You can use the following query to determine folders with high folder counts.
SELECT P.Name AS FolderName, P.Path, COUNT(PT.ProjectID) AS 'Number of folders found'
FROM Projects P
JOIN ProjectTree PT
ON PT.ProjectID = P.ProjectID
WHERE P.FolderType = 1
AND P.Deleted = 0
GROUP BY P.Name, PT.ProjectID, P.Path
HAVING COUNT(PT.ProjectID) > 1000
Jeff Barker | Senior Consultant - PLM Solutions, CEPA, CSWS-D