>>>On SQL clusters most often they use enterprise class high performance SSD solutions, while simple drive shares do not demand such storage.
>
>Dating back to last century when Windows servers slowed down +++ with thousands of files in a folder, we created a few hundred sub-folders and distributed filenames = unique compound name from fields in the file's database record. Worked well and still does 20 years later. Files are transported via IIS so not bad security either - would not want to give individual users access to those folders.


Interesting... I have not thought about that yet...