Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Both versions are returning 152 rows but, the additional text in the with calculation mode has inflated each row by and additional 59 bytes or 67% more so the amount of data needed to travel over the network pipe will be 22,192 bytes (21.67 KB) rather than 13,224 (12.9 KB). So, a small piece of of avoidable text has inflated the amount of data travelling over the network by 11KB amd and this is for just 152 rows of a 9,000 row data-set, scale this up to the millions, billions and in the case of big-data trillions and beyond, and this will really begin to take hold.

...