▲ | jiggawatts 2 days ago | |
Absolutely fascinating! It’s precisely these orthogonal, secondary concerns that make every industry more difficult than people on the outside might think. Articles like yours shed light on these challenges. I’m reminded of a recent project working on a (small!) data warehouse where for the first time in my career I had to not only be concerned with theoretical performance of queries, such as the presence or absences of indexes, but orthogonal concerns such as the time taken to rewrite terabytes of data on disk during night ETL jobs… combining with the “change rate” of the source data. Your article is a similar concern that only specialists in the in the industry are even aware of: it’s not enough to logically route connections — a challenging optimisation all by itself — but there are these competing physical optimisation issues as well that need to be simultaneously optimised! |