News for hackers. Stuff that matters.
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.