News for hackers. Stuff that matters.
Re:SQLite is 35% Faster Than The Filesystem (2017) by laurent123456 on Tuesday July 20, 2021 @02:47PM (#27897603)
Is it a known issue that the filesystem on Windows 10 is so slow? Being 5 times slower than macOS was roughly my experience but I thought there was just something wrong with my Windows laptop. I can't find any benchmark or explanation about this.
Re:SQLite is 35% Faster Than The Filesystem (2017) by jjoonathan on Tuesday July 20, 2021 @03:02PM (#27897787)
It isn't just Windows 10, as far as I know every version of windows has always wanted to spend like a minute (or multiple minutes!) slowly counting the files before it proceeds to slowly delete them one by one... until it finds one that's open in a background process and nixes the whole operation in a half complete state. 5 times slower sounds conservative. It's awful.

Hey, maybe they could put rounded corners on the file deletion window, I bet that would fix it!

Re:SQLite is 35% Faster Than The Filesystem (2017) by mikestew on Tuesday July 20, 2021 @03:12PM (#27897919)
The only reason I'm posting on HN right now is because I dared to right-click a folder on a network share. MyFolderName (not responding), whelp, guess I'll go fuck off for 60 seconds while every item in that shortcut menu opens a network connection, navigates to...or whatever the hell it's doing. Yeah, I know, use the CLI. OTOH, I argue: fix your broken UI.

I worked at MSFT for eight years as a full-time, Flavorade-guzzling employee, and fifteen years later rarely a day goes by that I don't question how Microsoft manages to get anyone to buy that steaming pile they call an operating system.

Re:SQLite is 35% Faster Than The Filesystem (2017) by williamvds on Tuesday July 20, 2021 @03:39PM (#27898266)
Most people don't buy Windows - it just comes with their computer, thanks to Microsoft's deals with OEMs.

Kids get accustomed to Windows and Microsoft Office in schools thanks to Microsoft's lobbying, so when they grow up they keep using Windows and pay for Office.

Everyone uses Windows and Microsoft Office, so most companies and organizations have to pay for licenses for each of their employees.

People know Windows, so they develop on Windows, so they get locked into yet more Microsoft products and libraries and have to run Windows on servers. That's yet more licenses for a Windows and for Visual Studio.

Their business strategy would almost be impressive if it weren't terrifyingly harmful.

Re:SQLite is 35% Faster Than The Filesystem (2017) by gavinray on Tuesday July 20, 2021 @03:48PM (#27898379)
Windows as an OS is... not the best. I miss Ubuntu/Pop!_OS. Switched due to MIDI controller driver compatibility issues that seemed immune to any WINE hackery =/

I actually really like the rest of what Microsoft does though.

VS Code, TypeScript, creating the Language Server Protocol, the .NET Foundation/.NET in general and C#, the list goes on and on. They're an impactful organization which (depending on what kind of software you build/what you write) probably has a significant impact on your day-to-day experience as a developer.

The benefits of vertical integration can have when you (for lack of a better word) "own" these things can be beneficial for the end-user/developer, ignoring whatever kind of anti-competitive arguments there are.

It's the same argument I hear from Apple users -- Apple stewards their digital experience and gives them continuity end-to-end.

Microsoft -- by nature of owning my OS, IDE, the specification and dev team driving my primary language, a cloud provider, and having their fingers in all of these parts of my digital life -- has the ability to be really awesome for me.

They could also do really sinister things if they wanted and I'd be real fucked I suppose, but that's a(n unlikely) risk I accept.

Re:SQLite is 35% Faster Than The Filesystem (2017) by chungy on Tuesday July 20, 2021 @03:21PM (#27898011)
> rarely a day goes by that I don't question how Microsoft manages to get anyone to buy that steaming pile they call an operating system.

"But muh games!"

Re:SQLite is 35% Faster Than The Filesystem (2017) by notriddle on Tuesday July 20, 2021 @05:30PM (#27899631)
Yeah, this but unironically.

The Windows filesystem has dismal performance. The Windows graphics stack is arguably better than Linux’s. And it’s not just the drivers, so you can’t just blame it on GPU vendors, though poor support from a certain popular GPU vendor definitely doesn’t help.

Some of it is just the little things, like doing mouse movement at very high priority in kernel space [1] [2]. Other parts are bigger and more impressive, like allowing the graphics driver to crash/upgrade/restart without you also losing all of your open windows.

[1]: https://reactos.org/wiki/Techwiki:Win32k/desktops#win32k.21P...

[2]: https://devblogs.microsoft.com/oldnewthing/20061117-03/?p=28...

Re:SQLite is 35% Faster Than The Filesystem (2017) by puzzlingcaptcha on Tuesday July 20, 2021 @03:49PM (#27898381)
Yeah, 'cause the incredible fragmentation of Linux GUI toolkits and windowing systems is so fun to deal with. Year of Linux on the Desktop when.
Re:SQLite is 35% Faster Than The Filesystem (2017) by blooalien on Tuesday July 20, 2021 @04:47PM (#27899103)
> Year of Linux on the Desktop when.

Couple decades ago for me.

> Yeah, 'cause the incredible fragmentation of Linux GUI toolkits and windowing systems is so fun to deal with.

Sounds like probably "never" for you. You seem hostile toward Linux, so you're probably better off sticking with whatever you use currently.

Re:SQLite is 35% Faster Than The Filesystem (2017) by gnubison on Tuesday July 20, 2021 @11:34PM (#27902067)
I don’t think calling GP “hostile to Linux” after they critiqued one part of the ecosystem is very fair. All systems have their flaws, and if judging part of a system negatively makes you hostile to that system, then I guess Linus Torvalds is hostile to Linux too.
Re:SQLite is 35% Faster Than The Filesystem (2017) by blooalien on Wednesday July 21, 2021 @02:19AM (#27902919)
I no longer care. None of it matters one little bit anyhow.
Re:SQLite is 35% Faster Than The Filesystem (2017) by chungy on Tuesday July 20, 2021 @04:25PM (#27898834)
Just take a look at the Windows desktop versus Linux desktop. The Windows desktop is far more fragmented and discongruous.

With Linux, the main difference is whether your desktop is primarily Qt or GTK. Sometimes an app using the other toolkit will look kind of funny, but most of those differences are paved over by any competent distro (eg: Debian, Fedora, Ubuntu, OpenSUSE...).

Re:SQLite is 35% Faster Than The Filesystem (2017) by motogpjimbo on Tuesday July 20, 2021 @04:56PM (#27899203)
There are two windowing systems on Linux - the old one and the new one.

GUI toolkits are irrelevant to games.

Re:SQLite is 35% Faster Than The Filesystem (2017) by gameswithgo on Tuesday July 20, 2021 @03:29PM (#27898129)
yeah maybe instead of making fun of that major industry other operating systems should treat it as an opportunity to gain market share.
Re:SQLite is 35% Faster Than The Filesystem (2017) by pfraze on Tuesday July 20, 2021 @04:10PM (#27898641)
SteamDeck is particularly interesting because of how much it is tackling that industry head-on. From the perspective of a mobile gaming console, the fact that it’s a PC is awesome. From the perspective of advancing gaming on Linux, it’s even more exciting
Re:SQLite is 35% Faster Than The Filesystem (2017) by vagrantJin on Tuesday July 20, 2021 @03:56PM (#27898472)
> rarely a day goes by that I don't question how Microsoft manages to get anyone to buy that steaming pile they call an operating system.

Haha. Maybe because it works? I do miss XP though. It felt like the only OS that can work as well on a PC and a Tank.

Re:SQLite is 35% Faster Than The Filesystem (2017) by xxs on Tuesday July 20, 2021 @03:21PM (#27898020)
This has very little to do with Windows, itself. The issue is explorer that tries to estimate sizes and put the files in the recycled bin. Also likely it checks all the permissions while counting.

Try the command line: "rmdir /s" and it's quick.

Re:SQLite is 35% Faster Than The Filesystem (2017) by mackwell on Tuesday July 20, 2021 @03:33PM (#27898194)
I think for the purpose of this discussion, explorer IS Windows. It is the UI that we all wish didn’t have these issues. I like using the command line / powershell when I’m on Windows for large file operations, but sometimes I still go to drag files around out of habit and quickly remember I have made a huge mistake as everything grinds to a halt / takes forever. On Linux and MacOS GUI file operations most of the time seem like they are just a visual way to call the same operations you’d be using on the command line.
Re:SQLite is 35% Faster Than The Filesystem (2017) by xxs on Tuesday July 20, 2021 @03:52PM (#27898415)
My habit is shift+del for windows; but most of the time I use cygwin anyways.

>I think for the purpose of this discussion, explorer IS Windows.

The article is about the file system, not the UI.

Re:SQLite is 35% Faster Than The Filesystem (2017) by GordonS on Tuesday July 20, 2021 @03:55PM (#27898446)
This is true, but I don't understand why Explorer has been plagued with performance issues (and some of those intermittent; I presume based on network status) since forever.

I'm actually a big fan of Windows on the desktop, and as long as I avoid Explorer, I have no issues at all with file system performance while I'm developing, working from the command line, VS Code and Rider, and working with containers and WSL - all works great. But Explorer is such a central component of Windows that it affects pretty all users. I genuinely don't understand how it can be so rubbish ¯\_(ツ)_/¯

Re:SQLite is 35% Faster Than The Filesystem (2017) by qwertox on Tuesday July 20, 2021 @04:08PM (#27898618)
Sometimes it's some .dll extensions which get loaded into explorer.exe which cause these problems.

I once had a PDF file on the desktop and for some reason this file was causing explorer.exe to freeze under certain circumstances. It's all a big mistery.

Re:SQLite is 35% Faster Than The Filesystem (2017) by blooalien on Tuesday July 20, 2021 @04:52PM (#27899159)
> It's all a big mistery.

Such is the nature of closed source black box software.

Re:SQLite is 35% Faster Than The Filesystem (2017) by m9731526 on Wednesday July 21, 2021 @12:26AM (#27902318)
So true, I really have to say Explorer sucks. Recently I've been bothered by an issue that it tries to fully read every ts file, like maybe it's trying to read a Typescript file, but in my recent cases they are usually streamed video files of several GBs... It just never gives up and use my disk usage at 100%, I just have to kill explorer.exe everytime. I even tried messing with Registry about ts file but that's no good.

And even its Item Handler system is flawed. Still about .ts, it could stutter when I open context menu on ts files, then freeze forever if I hover over just 1 bit on "Open with" menu.

Re:SQLite is 35% Faster Than The Filesystem (2017) by jjoonathan on Tuesday July 20, 2021 @04:18PM (#27898753)
What about refusing to delete files that some process has open in a dangling descriptor? Is that just a GUI thing? I'm pretty sure it isn't.

Also, is there a better way to hunt down the background process than sysinternals? It seems pretty ridiculous that a low level debugging tool is required to do something as modest as reliably move and delete files, but I never heard of a better workaround.

Re:SQLite is 35% Faster Than The Filesystem (2017) by poisonborz on Tuesday July 20, 2021 @04:36PM (#27898958)
LockHunter is a nice right-click utility for this
Re:SQLite is 35% Faster Than The Filesystem (2017) by blooalien on Tuesday July 20, 2021 @04:50PM (#27899137)
You just outed yourself as a "power user". ;)
Re:SQLite is 35% Faster Than The Filesystem (2017) by xxs on Tuesday July 20, 2021 @06:29PM (#27900147)
>What about refusing to delete files that some process has open in a dangling descriptor?

This is how it is on Windows. Linux handles open file deletion a lot better.

Re:SQLite is 35% Faster Than The Filesystem (2017) by tyingq on Tuesday July 20, 2021 @03:09PM (#27897883)
I think that's warts in the file explorer more so than warts in the system itself.
Re:SQLite is 35% Faster Than The Filesystem (2017) by logifail on Tuesday July 20, 2021 @03:39PM (#27898261)
> warts in the file explorer more so than warts in the system itself

I'm struggling to understand why one shouldn't treat the behaviour of explorer.exe as simply part of the Windows system.

Are there third-party explorer.exe alternatives available?

If so, during Windows install, where do I click to _not_ install the MSFT explorer.exe and instead select one of the better alternatives?

Re:SQLite is 35% Faster Than The Filesystem (2017) by tyingq on Tuesday July 20, 2021 @04:00PM (#27898513)
I'm not excusing it, I'm just saying where the performance issue is. Filesystem ops are reasonably fast if you use the command line, do it programmatically, etc. With the caveat that Windows Defender can slow things down.
Re:SQLite is 35% Faster Than The Filesystem (2017) by edoceo on Tuesday July 20, 2021 @03:45PM (#27898339)
The last time I really used Windows (Win2k) there were alternative WinShell options.

You'd set a regkey to your program. There used to be a 3.1 style Program Manager - I miss that one

Re:SQLite is 35% Faster Than The Filesystem (2017) by jjoonathan on Tuesday July 20, 2021 @04:12PM (#27898670)
Is "you can't delete a file if anything has it open" an explorer thing? I thought that was an OS thing.
Re:SQLite is 35% Faster Than The Filesystem (2017) by tyingq on Tuesday July 20, 2021 @05:52PM (#27899857)
That's an OS thing, but "wait forever while it grinds, finds one of those, and bails half finished" isn't.
Re:SQLite is 35% Faster Than The Filesystem (2017) by anigbrowl on Tuesday July 20, 2021 @03:53PM (#27898434)
I think it's file manager in particular. When I need to do something muscular I open a DOS box and just do it at the command line. It feels plenty zippy though I haven't bothered to do any benchmarks; I have to confess I've never learned Powershell because it's so easy to get most things done with command.com.

Although Windows remains my favorite environment I share the annoyance at how MS really polishes some things while failing on basic functionality, when they definitely have the resources and skills to fix that. Every time my wifi or WAN hiccups I wonder why Windows still lacks decent network history/QOS tools out of the box.

Re:SQLite is 35% Faster Than The Filesystem (2017) by mickotron on Tuesday July 20, 2021 @05:17PM (#27899478)
Yep, "dir /s /b | findstr x" is way quicker than searching for files in explorer.
Re:SQLite is 35% Faster Than The Filesystem (2017) by qwertox on Tuesday July 20, 2021 @04:06PM (#27898584)
Oh man... Deleting a folder with a million files, or even only 100.000 is painful in Windows. You need to use the command line in order to sanely delete such folders.
Re:SQLite is 35% Faster Than The Filesystem (2017) by metalliqaz on Tuesday July 20, 2021 @03:07PM (#27897862)
it does that for the UI

For power users, you're much better off using the command line tools

Re:SQLite is 35% Faster Than The Filesystem (2017) by jjoonathan on Tuesday July 20, 2021 @04:00PM (#27898516)
I have a different power user workaround: I don't use Windows if I can at all avoid it.

EDIT: Does the CLI override the "open in background" check? Or do you still need Mark Russinovich sysinternals to reliably perform elementary file system administration tasks in Windows?

Re:SQLite is 35% Faster Than The Filesystem (2017) by shawnz on Tuesday July 20, 2021 @02:57PM (#27897717)
See here for some notes from the WSL team why certain filesystem operations that would be fast on Linux are slow on Windows:

https://github.com/microsoft/WSL/issues/873#issuecomment-391...

https://github.com/microsoft/WSL/issues/873#issuecomment-425...

Re:SQLite is 35% Faster Than The Filesystem (2017) by nivenhuh on Tuesday July 20, 2021 @03:44PM (#27898318)
Thanks for the links -- one pro-tip that stood out to me was to use the D: drive (because it's likely to have less filter drivers attached).

"Windows's IO stack is extensible, allowing filter drivers to attach to volumes and intercept IO requests before the file system sees them. This is used for numerous things, including virus scanning, compression, encryption, file virtualization, things like OneDrive's files on demand feature, gathering pre-fetching data to speed up app startup, and much more. Even a clean install of Windows will have a number of filters present, particularly on the system volume (so if you have a D: drive or partition, I recommend using that instead, since it likely has fewer filters attached). Filters are involved in many IO operations, most notably creating/opening files."

Re:SQLite is 35% Faster Than The Filesystem (2017) by hughrr on Tuesday July 20, 2021 @03:47PM (#27898357)
I'm going to have to complain about this because in real world use these are far less of a problem than MFT contention on sub-900 byte files generated by typical unix environments. Particularly things that are lockfile heavy and VCSs etc are the most painful. The WSL thing reads like an excuse here. If you actually go and look at what's happening it's small files which are the damage multiplier.

I think the real issue is that you shouldn't mix the two operating system paradigms and it's far better to just run Linux in a VM and benefit from the near native performance at the cost of a tiny bit of inconvenience. It's not a bad option when you consider the remote IDE capabilities that VScode gives you, which is the one product they're doing 100% right.

Re:SQLite is 35% Faster Than The Filesystem (2017) by rossy on Tuesday July 20, 2021 @08:38PM (#27900970)
I'm sorry, but I find that hard to believe when the linked posts are from a Microsoft employee, who says repeatedly that the problem isn't a simple as "NTFS is slow," that they spent a release optimising NTFS, they've gotten rid of all the low hanging fruit and so on. I don't see why they'd be making excuses for NTFS when the underlying problems seem to be much more fundamental to Windows, which is much worse. You say you discovered the MFT contention issue when you were working on Subversion a decade ago, but these posts are from 2018, so I'm inclined to believe that the MFT contention issue has been mitigated and the real issues really are things like filter drivers, like they say.

I'm also not sure there's two paradigms here, if by that you mean there are workloads more suited to Linux and workloads more suited to Windows. Are there any file system operations that are actually faster on Windows? I'm still inclined to believe, like they say, that "file operations in Windows are more expensive than in Linux," even if large files are less impacted than small files.

I really hope Microsoft can improve this, rather than just throwing it under the rug and saying to use Linux VMs, even if they have to make drastic changes like deprecating filesystem filter drivers completely. I think a lot of us depend on the performance of software that was designed for fast filesystems and ported to Windows (not just Git, either.) I also think a lot of tasks fundamentally use a lot of small files. After all, what is source code?

Re:SQLite is 35% Faster Than The Filesystem (2017) by hughrr on Wednesday July 21, 2021 @02:49AM (#27903061)
No it’s still MFT contention. Someone at my company independently discovered the same problem recently with git on WSL.

MSFT don’t listen to or care about their customers findings from experience. That’s why canned our partner status.

In this case they haven’t touched NTFS at all - that’s out right rubbish.

I pointed out the paradigm mismatch already. Run unix loads on unix not NT.

Re:SQLite is 35% Faster Than The Filesystem (2017) by hughrr on Tuesday July 20, 2021 @03:28PM (#27898114)
This is actually a problem with the design of NTFS. Small files are stored in the MFT (Master File Table) which results in heavy lock contention and slowness if you're doing lots of small files which is what most people tend to do these days.

NTFS really does quite well on large files but small Unixy things and source code it is hopeless on. I first learned about this trying to make Subversion fast about a decade ago.

You can tune some of this out with fsutil but it gives marginal gains. It's depressing though when you have a VM on windows that is faster than the native OS filesystem :(

Re:SQLite is 35% Faster Than The Filesystem (2017) by Someone1234 on Tuesday July 20, 2021 @03:06PM (#27897849)
Windows' slow performance when dealing with millions of tiny files per hour (e.g. <50 KB) and inability to offer fine-grain IO throttling for processes was why we moved from Windows to Linux in a previous career. Linux handles this scenario in its stride, Windows chokes (and, no, "background" IO priority on Windows isn't a solution).

Simply moving from files to a DBMS wasn't an option, since the whole point of this edge system was to allow third parties to FTP/SFTP/FTPS/etc in and out, to put/get files. We would have had to re-implement multiple transfer technologies/protocols to have a file-less database system (which didn't make cost-effective sense).

Re:SQLite is 35% Faster Than The Filesystem (2017) by jokoon on Tuesday July 20, 2021 @03:39PM (#27898260)
One thing I know, is that mechanical disk drives have suffered a very big drop in performance in windows 10.

I've asked this question several times, "Why would an OS need an SSD to work normally and be responsive when it was already fast without SSD some years ago", and I often get responses like I don't know how computers work, that win10 takes advantages of SSD and that it cannot work well on old techs. Even when you have a high amount of RAM and use a HDD, it's still slow.

I'm still looking for a decent filesystem or kernel developer to answer that question with a good enough explanation, because to me, I'm either stupid, or there is negligence or some attempt to increase sales of SSD. Maybe windows now uses SSD as some sort of "secondary RAM", and thus it will never be fast with a HDD.

I mean, linux desktops seem to still be fast enough with mechanical HDD.

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.
Re:SQLite is 35% Faster Than The Filesystem (2017) by outworlder on Tuesday July 20, 2021 @03:30PM (#27898150)
Known issue? Yes. One of the reasons many games have faster load times under Wine when compared with the actual OS.

No clue on what the actual underlying issue is. And it's not like we can easily switch filesystems to compare.

Re:SQLite is 35% Faster Than The Filesystem (2017) by modeless on Tuesday July 20, 2021 @03:06PM (#27897843)
If you're doing a bunch of I/O, it's often worth it to go into Windows Defender settings and turn off "real time protection" temporarily. It can make a big difference.
Re:SQLite is 35% Faster Than The Filesystem (2017) by dexterhaslem on Tuesday July 20, 2021 @03:30PM (#27898148)
absolutely, and for directories for your projects /places where lots of files thrash about, add those dirs as exceptions in the options.

i mean i added c:\ as an exception because i do not need realtime av but i dont think it will actually work like that

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. "

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.
Re:SQLite is 35% Faster Than The Filesystem (2017) by qwertox on Tuesday July 20, 2021 @04:04PM (#27898556)
Alone the fact that it is twice as slow as Windows 7 is puzzling.

One would assume that it gets better with every upgrade, but a factor of 2x worse seems to indicate that they added some kind of logging or something.

Like the logging/access system which Android has started to integrate with Android 9 where every access needs to go through the StorageManager.

Re:SQLite is 35% Faster Than The Filesystem (2017) by mqus on Tuesday July 20, 2021 @03:27PM (#27898109)
I think this was known for a long time. E.g. Git takes forever, compared to the equivalent operations in Linux
Re:SQLite is 35% Faster Than The Filesystem (2017) by naikrovek on Tuesday July 20, 2021 @03:12PM (#27897917)
Yes. NTFS filesystem performance when accessing many small files rapidly is slow. It's an NTFS limitation, not any specific version of Windows.

I believe it is caused by some per-file overhead that NTFS incurs, though I'm not 100% sure.

Re:SQLite is 35% Faster Than The Filesystem (2017) by masklinn on Tuesday July 20, 2021 @03:31PM (#27898161)
> It's an NTFS limitation, not any specific version of Windows.

I would guess their surprise is because the charts specifically show Win10 as being 100% slower than Win7 in the first chart, and still a good 30% slower in the best case (third chart).

That's not NTFS v other, that's Win7 v Win10, both on NTFS.

Re:SQLite is 35% Faster Than The Filesystem (2017) by naikrovek on Tuesday July 20, 2021 @03:41PM (#27898286)
NTFS comes in different versions, you know.

I don't care what version of Windows you're on, or what version of NTFS you're on; NTFS is dog slow on small files.

I am not sure that NTFS has versioned between Windows 7 and Windows 10, so let's just assume that it hasn't.

If the limitations of the filesystem do not change between operating systems, then what must change is how the OS deals with the filesystem limitation, and/or attempts to work around them.

Windows 7 does better than Windows 10. That doesn't mean NTFS isn't slow.

Re:SQLite is 35% Faster Than The Filesystem (2017) by masklinn on Tuesday July 20, 2021 @03:46PM (#27898343)
> NTFS comes in different versions, you know.

A completely pointless remark when versions of NTFS and Windows are correlated. And AFAIK there's been no updated to NTFS itself since the addition of symlinks in NTFS 3.1, released with Windows XP. All "filesystem features" since were added at the level OS, using existing NTFS features.

> If the limitations of the filesystem do not change between operating systems, then what must change is how the OS deals with the filesystem limitation, and/or attempts to work around them.

Yeees? Which would make the issue vary based on the specific version of Windows maybe?

> Windows 7 does better than Windows 10. That doesn't mean NTFS isn't slow.

No, but I never claimed such a thing. I'm just pointing out that your assertion that

> It's […] not any specific version of Windows.

is bullshit.

Re:SQLite is 35% Faster Than The Filesystem (2017) by naikrovek on Tuesday July 20, 2021 @04:50PM (#27899134)
>> It's […] not any specific version of Windows.

> is bullshit.

No, it's not. NTFS is slow, even when it's running under Linux. NTFS has a very pronounced weakness, here.

Performance changing between Windows 7 and Windows 10 means that ON TOP OF NTFS there are other performance problems in Windows 10. It does not mean that it isn't an NTFS problem in the case of Windows 10 -- it means that it isn't ONLY an NTFS problem in the case of Windows 10. It's an NTFS problem in addition to whatever other things Windows 10 is screwing up, when compared to Windows 7.

The difference between Windows 7 and Windows 10 alone? Yes, that's entirely because of Windows 10 and not because of NTFS. There. I never disagreed with that.

Re:SQLite is 35% Faster Than The Filesystem (2017) by Tostino on Wednesday July 21, 2021 @09:22AM (#27905888)
You are making a point that truly doesn't matter.
Re:SQLite is 35% Faster Than The Filesystem (2017) by naikrovek on Wednesday July 21, 2021 @07:58PM (#27913678)
everyone on HN does that 100% of the time they comment. it's not the "things that matter" section of the site, it's the "comment" section.
Re:SQLite is 35% Faster Than The Filesystem (2017) by passivate on Tuesday July 20, 2021 @03:31PM (#27898159)
Personally, I have not seen that. Which operations did you think were slow? Small-block/large-block?, sequential/random I/O ? etc, etc. Or did you just mean general productivity?
Re:SQLite is 35% Faster Than The Filesystem (2017) by animatedb on Tuesday July 20, 2021 @06:21PM (#27900090)
I know that the open function on files is very slow. This makes opening many small files very slow.
Re:SQLite is 35% Faster Than The Filesystem (2017) by jacobwilliamroy on Tuesday July 20, 2021 @03:09PM (#27897882)
My theory is that the OS likes to do a deep inspection of your files in order to feed microsoft's machine learning models.
Re:SQLite is 35% Faster Than The Filesystem (2017) by naikrovek on Tuesday July 20, 2021 @03:24PM (#27898054)
your theory is based on ignorance and suspicion instead of anything real.
Re:SQLite is 35% Faster Than The Filesystem (2017) by jacobwilliamroy on Tuesday July 20, 2021 @08:16PM (#27900839)
And what is your's based on? It's proprietary software. We're not supposed to know how it works or what it's doing.