4 ms·
> And yet for any but toy-level (and logic/relational math research) programming, you have to pay attention to how it works under the hood. Maybe 30 years ago.
by lmm 8y ago
> And yet for any but toy-level (and logic/relational math research) programming, you have to pay attention to how it works under the hood.
Maybe 30 years ago. It's really not so important nowadays. Computers are fast.
> For practical use of SQL, you need to be able to choose between equivalent queries based on how the database engine actually turns them into lookups.
Maybe there are some cases where you need to, but there are also million-dollar businesses that have succeeded while only ever writing their SQL queries as naively as possible. The notion that all non-toy practical uses need to understand such low-level details is just utterly false.
- zbentley 8y ago> there are also million-dollar businesses that have succeeded while only ever writing their SQL queries as naively as possible. Citation needed. Given engineering staff sizes and the amount of performance problems RDBMSes have, that seems highly doubtful.
- lmm 8y agoPersonal working experience; afraid I'm not willing to name specific past employers here.