News for hackers. Stuff that matters.
Re:SQLite the only database you will ever need in most cases by simias on Thursday April 15, 2021 @05:41AM (#26818264)
That's sometimes true but it depends a lot on the filesystem used, and sometimes on the options used when building it. ReiserFS, ext4 and FAT 32 won't have the same performance profile.

I think breaking down large collections in subdirectories is mainly done in order to ensure that it'll work even with FS that don't deal well with very large directories and also because it makes inspecting the files manually a little more convenient given that many file explorers (and especially the GUI ones) can have trouble with large directories.

Re:SQLite the only database you will ever need in most cases by eru on Thursday April 15, 2021 @09:14AM (#26820051)
Yes, though I think there's some POSIX compatibility stuff that also makes big directories a hassle.
Re:SQLite the only database you will ever need in most cases by utxaa on Thursday April 15, 2021 @11:33AM (#26821695)
also ext4 (then 3 i think) used to look for dir entries linearly (it was a linked list of entries).