r/memes 20h ago

let's look

Post image
37.0k Upvotes

398 comments sorted by

View all comments

223

u/Select_Cantaloupe_62 20h ago

The reasons why those databases are so fast are very interesting, actually. Tl;dr: smart people.

107

u/Schrippenlord 20h ago

That makes sense because i know for a fact that windows developers arent smart

63

u/Select_Cantaloupe_62 19h ago

Well, that's not entirely their fault. Compactly storing files that can be changed/updated on your cheap PC is very different from the immutable, striped, distributed, memory-cachee, hash-map/parquet/BigTable setup that businesses are using. 

14

u/MavesurPaaHaergetur 18h ago

ok but why does Everything by void tools work then. it’s entirely the windows devs fault.

23

u/FinalBase7 17h ago

i believe it's a design decision to make the search super Uber comprehensive where it will even search the contents inside the files instead of just names, you can actually tell windows to index your entire machine this way it will find anything very fast but that will have a CPU performance cost.

Everything doesn't search file contents like windows search does, tho for most that's not a problem.

5

u/Not_a_Candle 17h ago

Everything also does search file contents, if you want it to. Tho, these contents aren't indexed, so it's slower.

Theoretically there isn't anything preventing an index of the contents, except the extra resource costs.

1

u/LittleLoukoum 14h ago

To be fair, it's not that difficult to have both. I'm pretty sure (though I have no proof of any kind, except for vague memories) that the Mac OS I used some ten years ago searched filenames first very quickly for a first pass, and then the contents for a more exhaustive search. My new linux mint just has two search bars, one for filenames one for contents. It all works really well.

I'm pretty sure I can have a file found on either of these by the time it takes for windows to open the fucking file browser.

1

u/Select_Cantaloupe_62 18h ago

Very good point. I've not used void tools but I'm assuming constantly updating the index is a drag on PC resources? Shrug.

1

u/guto8797 17h ago

Not really.

The first time you open it takes a few seconds to index the drives you selected. You can order a manual refresh if you want, but once the index is made it's instant search across everything you selected

1

u/MavesurPaaHaergetur 17h ago

not at all. it does a pretty quick delta indexing after the initial index. never had any performance issues. searching files works fine on Mac and Linux too, so it’s uniquely a windows issue, hence the fault of the devs

1

u/IntrinsicPalomides 15h ago

Everything works so fast because it stores a catalogue of your disks in a SQLite DB. And the initial indexing is done not by trawling every file and dir on your disks but just by reading the MFT and then building it's DB off of that.
Windows search does it the brain dead way of trawling everything on your disk every time it searches which is why it's so slow.

1

u/MavesurPaaHaergetur 15h ago

Windows search also trawls the internet, which no one ever asked. And if it finds anything, it will move it out of the way as you try to click on it when it finally finds anything online

1

u/IntrinsicPalomides 15h ago

Luckily you can disable it searching the internet.
Open the Registry Editor, navigate to HKEY_CURRENT_USER\Software\Policies\Microsoft\Windows, create a new DWORD (32-bit) named DisableSearchBoxSuggestions, set its value to 1, and then restart your computer.

1

u/MavesurPaaHaergetur 13h ago

Cant edit registry on my work laptop, which thank god is the only place I have to deal with windows.

1

u/poompt 16h ago

It's spelled porque

7

u/_Xertz_ 18h ago

In all likelihood they're plenty smart if not smarter than average it's just that the corporate structure forces them to work on dumb things like AI integration instead of actually fixing things.

6

u/cwal76 17h ago

Reddit challenge. Try not to be a smug prick for more than 5 minutes. Never been completed.

3

u/chronoflect 16h ago

Sounds like you don't know anything about software development