3 ms·

People do not realize just how far industry practitioners take joins :) So my take is that users will find a way to take joins to the point where they do not sc

• m0xte 6y ago
  Usually they scale infinitely well until someone opens a PO for a Cray sized database cluster that burns kilowatts of power.
  • dman 6y ago
    Let me just say that I have seen queries that are megabytes in size with joins all over the place :)
    • m0xte 6y ago
      I’ve seen the same ones that do 3GB of reads to return ten rows. The point I was inelegantly making is that it is terrible doing this processing on every read rather than once at write.
      • dman 6y ago
        Correct!