News for hackers. Stuff that matters.
Re:Shopify Ruby on Rails distributed monolith runs 19M queri... by firefoxd on Wednesday November 29, 2023 @11:34AM (#38461572)
The db connections were poorly managed. Each query started by starting a new connection. It then checked if it failed, slept, retried, then ran. There were several queries called in loops, so the connection pool was always dry. The code spent most of it's time sleeping. Then the queries themselves were highly inefficient, bad joins, no indexes, etc. It was satisfying to fix the mess.
Re:Shopify Ruby on Rails distributed monolith runs 19M queri... by dunno7456 on Wednesday November 29, 2023 @06:02PM (#38466560)
I had two similar experiences in the past years: I added some database indices, the application become super fast, the rest of the team starts acting weird, I get shown the door.

At this point I'm pretty sure anything IT relate became a bullshit job.