Re:SQLite small blob storage: 35% Faster Than the Filesystem
by AstralStorm on Wednesday June 14, 2017 @02:10AM
(#14550928)
Which is why before making such broad statements they should check on the other platforms, which have much less broken file systems.
(Check Ext4, ZFS, UFS2, HPFS+ and APFS at least.)
What they did is check an untuned Ext4, UBIFS, HPFS+ and NTFS vs a tuned database in a single thread scenario. Especially misleading in the mmap case where synchronization would just kill the performance dead.
Conclusion seems to be that filesystems on windows are not well optimized for the usecase of reading and writing from many small files at once.
Which could explain poor windows performance in the benchmark (writing to 100,000 individual files).