top | item 44868468

(no title)

ElCapitanMarkla | 6 months ago

I started to notice this in a big way at my last job which I started in 2013. We were a rails shop and by about 2016 I was noticing most new hires would have no idea how to write a SQL query.

discuss

order

cultofmetatron|6 months ago

> most new hires would have no idea how to write a SQL query.

probably why people think rails is slow. our integration partners and our customers are constantly amazed by how fast and efficient our system is. The secret is I know how to write a damn query. you can push a lot of logic that would otherwise be done in the api layer into a query. if done properly with the right indexes, its going to be WAY faster than pulling the data into the api server and doing clumsy data transformations there.

strtok|6 months ago

1000%. It’s all about limiting those round trips to the database…

hollowturtle|6 months ago

You actually confirmed that rails is slow if the optimization is on the database server and doing data mangling in ruby is less efficient