News for hackers. Stuff that matters.

A comment on SQLite is 35% Faster Than The Filesystem (2017). Parent comment

Re:SQLite is 35% Faster Than The Filesystem (2017) by phepranto on Tuesday July 20, 2021 @04:12PM (#27898662)
At the end of the article it says:

"SQLite is much faster than direct writes to disk on Windows when anti-virus protection is turned on. Since anti-virus software is and should be on by default in Windows, that means that SQLite is generally much faster than direct disk writes on Windows. "

[ Parent | on HN ]
Re:SQLite is 35% Faster Than The Filesystem (2017) by wscott on Wednesday July 21, 2021 @06:03AM (#27904281)
This is a key point. Windows is starting up the anti-virus program and scanning every tiny file as it is written. This is less about NTFS being slow and more about anti-virus being considered a required overhead on Windows.
[ Parent | on HN ]