eromanowski
asked on
File System Optimization
I'm looking for suggestions on optimizing our application to list directories faster. Right now, it takes about a minute + to load the directories on a shared network drive.
Does anyone have any suggestions on how to break this out? Generate the file structure in a database and use the database to traverse the file structure? Break down actually directories into more sub-directories?
Thanks,
Eric
Does anyone have any suggestions on how to break this out? Generate the file structure in a database and use the database to traverse the file structure? Break down actually directories into more sub-directories?
Thanks,
Eric
ASKER
We have 78,000 directories. The application (written in vb6) uses an embedded Windows Explorer.
Well if you are attempting to walk all 78,000 at one time you are really lucky that it only takes about a minute to.
The only way to make it work faster is to move the files to the server doing the work, either physically on the box or if they are on a SAN, get the server connected to the SAN.
Doing this over the network will be murder, as you have found out.
The only way to make it work faster is to move the files to the server doing the work, either physically on the box or if they are on a SAN, get the server connected to the SAN.
Doing this over the network will be murder, as you have found out.
ASKER
One idea I had was to load all the directories into a database (via a script). We then could simulate folder browser until they actually drill down a file or folder within the structure. Would need some way to keep the database in sync with the file system.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you walking down the full tree in one shot?