3 ms·
Learning SQL is a software dev superpower at the moment. So many devs don't know SQL and it causes such pain. But mostly invisible pain because if you don't kno
by marcus_holmes 4y ago
Learning SQL is a software dev superpower at the moment. So many devs don't know SQL and it causes such pain. But mostly invisible pain because if you don't know SQL then you don't understand the horrible things your ORM is doing.
- rvdginste 4y agoExactly! Devs should learn SQL and should learn how their ORM works, what it is doing "behind the scenes". It is also a good idea to keep a sql profiler open when working with the application to see which queries are generated. When you do that regularly, you can often fix issues before they really become a problem. This is also useful even if you do not use an ORM. For example, an action might execute a loop with a query on the inside of the loop. It might be more performant to retrieve the data using one query and then loop over the results of that query.
- Waterluvian 4y agoAbsolutely. I had a phase years back of chasing performance issues because your ORM does stuff like thousands of related queries for data you don’t actually need.