3 ms·
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 softw
by phepranto 5y ago
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. "
- wscott 5y agoThis 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.