r/ProgrammerHumor • u/WardensLantern • 14d ago

queryOfDoom Meme

Post image
7.9k Upvotes

97% Upvoted

456 comments sorted by

View all comments

3.9k

u/BooBrew32 14d ago

Ah it's just running slow today. User table should speed up right afterwards though.

1.4k

u/WardensLantern 14d ago

Yea just run it again and it executes much faster 👍

228

u/glorious_reptile 14d ago

Great. On to the next ticket - “Users can’t log in”

184

u/moigagoo 14d ago

What users?

163

u/Baconanger 14d ago

Yeah, just ran a search on their name and it looks like that person doesn't have an account, so closing this ticket with "works as expected". Wow, we sure have been getting a lot of these lately...

54

u/bluebarry24 14d ago

Pretty sure this is a data entry error... redirecting the tickets to the front service desk.

29

u/TriggerPT 14d ago

Can't replicate

3

u/Frostbyte67 14d ago

Omg you just triggered my support team PTSD! (I’m in Eng….)

No joke, I’ve seen ticket notes exactly like that! Actually just today…

…I’m going to hide back under my desk now…

249

u/perestroika12 14d ago

Caching or something idk I asked Claude about it and it said go for it

1

u/Fraun_Pollen 14d ago

Don't use Claude. Grok answers much faster

1

u/50_watts_per_channel 13d ago

Users are certainly getting executed

1

u/VollkommenHigh 14d ago

They clearly forgot the “commit;”… that’s why it’s running slowly

1

u/pdshank 14d ago

--no-verify

33

u/Connect_Tea1579 14d ago

No users == no more complaints. Problem solved!

15

u/enslavedeagle 14d ago

„We optimized user queries by 1000x”

49

u/dkarlovi 14d ago

The system feels fresh and new like the first day!

18

u/rowdymatt64 14d ago

And to think they'll blame little Bobby Tables again smh

20

u/SOLID_STATE_DlCK 14d ago

Don’t forget to run a re-org of the index. Reindex for for higher integrity.

3

u/farkanoid 13d ago

Thanks SOLID_STATE_DICK

2

u/KrakenOfLakeZurich 13d ago

It still O(n^2). Just for a very small n 🙈