My first engineering job was doing ColdFusion in 2012. Even at the time ColdFusion was considered dated, and it was extremely slow.
When I learned SQL at that job, and when I learned you can squeeze a lot of computation out of SQL, it was huge for me. I started doing as much pre-processing with SQL as I could, just because it felt like it was giving me a lot of free performance upgrades.
Yeah I have yet to really open the hood and learn more about query plans (which enable the computation ability you mention). I’ve been running into OOM errors all week and luckily the system gives me advice on where to find the cause. I’d like to learn more about how to determine what parameters to set (like partitioned vs broadcast joins) because even after all this time using SQL it still feels like an alien technology to me especially when my SQL is syntactically correct but causing worker explosions left and right lol. There’s no better feeling than refactoring the code and seeing a job that used to time out run and you see how much data is being processed efficiently like that.
Honestly even very crappily written SQL will probably still be faster than ColdFusion, particularly if you're using stored procedures. I'm not going to claim I'm the world expert of anything, and the SQL I write was never hyper-optimized, but ColdFusion was just ridiculously slow.
When I learned SQL at that job, and when I learned you can squeeze a lot of computation out of SQL, it was huge for me. I started doing as much pre-processing with SQL as I could, just because it felt like it was giving me a lot of free performance upgrades.