Compression

[davidathompson]

trafficstars

If you were to add compression to this, where would you do it? At the payload area, or the full stream itself?

[MindFlavor]

I really can't say, I think it depends on the payload and the packet size. Maybe it will be easier to compress the single packets - provided they are big enough. It would be interesting to use an external dictionary: most rows have repeated data so the compression ratio should be excellent (SQL Server does something like that in the compressed ColumnStore indexes).