Good afternoon...
I wanted to find out the mechanics of the Folder.FIles command.. I'm trying to buid some queries in Excel that pull files from within a folder hierarchy...Unfortunately the hierarchy is sub-optimal...There are 140 folders below the topmost folder (it's already 3 folders deep in the overall hierarchy), 120 of which are below the second level (20 folders). Total data in all folders is 8G.... It takes close to 30 minutes to compete a query that only gives a table of a file listing (with the default columns) across a 200 mb connection over VPN... I'm guessing the issue lies in recursion, but wanted to see if anyone knew precisely how the function works under the hood so that I can give a coherent explanation to my superiors for performance issues...
I wanted to find out the mechanics of the Folder.FIles command.. I'm trying to buid some queries in Excel that pull files from within a folder hierarchy...Unfortunately the hierarchy is sub-optimal...There are 140 folders below the topmost folder (it's already 3 folders deep in the overall hierarchy), 120 of which are below the second level (20 folders). Total data in all folders is 8G.... It takes close to 30 minutes to compete a query that only gives a table of a file listing (with the default columns) across a 200 mb connection over VPN... I'm guessing the issue lies in recursion, but wanted to see if anyone knew precisely how the function works under the hood so that I can give a coherent explanation to my superiors for performance issues...
