I tried this with half a million once ... admittedly under NT, I don't know how much the file system has improved since then for this sort of nonsense.
I rapidly came to the conclusion that it was vastly better to put all the files into SQL Server and use indexes rather than try to use the filing system.