FileSystemObject Memory Usage

[rep4tech]

Greetings,

I've written a file move script. The script, which is complete, works really well. It basically runs through each file using FileSystemObject and sorts through the files based on date and moves them into a directory based on the week it was created (1-52).

However, the initial time I run the script it will run against 2 million files (or substantially more). Does FileSystemObject load all the file names into memory and then look at them or does it look at them one at a time? I'm concerned the server will not be able to handle loading that many files into memory.

Thank you in advance!!
Eddie

 

[Geates]

It collects all the files at once. Each file is an object. Collecting 2M+ will be quite taxing. I did this once with logon audit files and it took hours to collect them.

I recommend an alternative...a DOS command.

send [red]all files[/red] in [blue]bare format[/blue] to files.txt

dir [red]*.*[/red] [blue]/b[/blue] > files.txt

Then open the file a get each file as an object

set objStream = objFSO.OpenTextFile("files.txt")
do while not (objStream.AtEndOfStream)
   strLine = objStream.ReadLine
   set objFile = objFSO.GetFile(strLine)
   'move file
loop
objStream.close

-Geates

"I hope I can chill and see the change - stop the bleed inside and feel again. Cut the chain of lies you've been feeding my veins; I've got nothing to say to you!"
-Infected Mushroom

"I do not offer answers, only considerations."
- Geates's Disclaimer

 

[rep4tech]

Hi Geates,

Thanks for the reply! I really glad I posted this question then, it would have been detrimental to bring down the server.

I'll take your suggestion!

Thanks again,
Eddie