To access files on ext3, and (if dir_index is not being used) what is the optimal directory depth vs the number of files per directory? Does file size effect this? The total number of files might be a factor, but there still should be an equation I think...
If you don't have the benchmarks to back it up, I would still be interested in what you think might be optimal and why? Maybe certain system calls take longer, or maybe your computer science knowledge suggests what might be the answer. Or, if you have examples from other file systems that could be very interesting too, but I want to know what the answer is without having a separate indexing mechanism such as the dir_index tune2fs option.
I have seen this question danced around, wondered the answer, but never found it. At this point, practically a database very well might be the answer. However, I still want to know what the answer would be for the file system.