News for hackers. Stuff that matters.
Re:SQLite is 35% Faster Than The Filesystem (2017) by Isthatablackgsd on Tuesday July 20, 2021 @03:06PM (#27897837)
Likely it is Windows Defender. Someone recently post the issue tracker for this particular issue and some are pointing at Defender as the cause of the I/O performance.

As a daily windows user, I'm not surprised if it is Defender. I have some files and folders in exclusion list because Defender was interfering with those files that the software is trying to use.

Re:SQLite is 35% Faster Than The Filesystem (2017) by boardwaalk on Tuesday July 20, 2021 @03:17PM (#27897967)
That’s probably part of it, but NTFS has just been slow forever and ever. Anything involving lots of small files is just pain. Perhaps it seems “normal” for anyone used to Explorer progress dialogs, but it’s not.

And Microsoft just doesn’t seem to care :-(.

Re:SQLite is 35% Faster Than The Filesystem (2017) by naikrovek on Tuesday July 20, 2021 @03:23PM (#27898048)
They care, as much as a group of people without a mind of its own can care, but it's a use case that was not common among windows software when NTFS was designed. Other design considerations were more important than high performance while writing or reading 1 million small files per minute.
Re:SQLite is 35% Faster Than The Filesystem (2017) by naikrovek on Tuesday July 20, 2021 @03:17PM (#27897972)
It's not Windows Defender. Not entirely, anyway. NTFS is slow when reading or writing lots of small files. It just is, and it always has been, and it's because of how NTFS was designed, if I am remembering correctly.