I think the takeaway here, as with most data problems, is be careful what you are indexing and why/how. What file systems optimize their indices for is not necessarily what your data needs indexed. In this particular example, because (among other reasons) users tend to prefer folders with smaller numbers of files, most operating systems naturally optimize their indices for that use case rather than folders with large numbers of files.
