/
Compress vs Throughput

Compress vs Throughput

Test Scenario 1

  1. Cooper Messages - 9K->10MB, 26892 messages, 1.427GB uncompressed size
  2. Measure time/throughput of Inbound HL7 Device -> QueueDevice (I->Q)
  3. Measure time/throughput of QueueDevice -> Null Device (Q->N)
  4. Clear Queues after each test
DateVersionRev

Simultaneous

Streams

Compression

Type

Compressed Size

MB*

Ratio

I->Q

(sec)

I-Q

m/sec

Q->I

(sec)**

Q->

m/sec

Notes
Nov 14, 201313.02.07R15d7299b191ce11IONIC ZIP108 MB92%13020671379Heavy CPU
Nov 15, 201313.02.07R15d7299b191ce12IONIC ZIP216 MB92%130413147366

Heavy CPU

Nov 14, 201314.01.0103607f2d382921

.NET ZIP MAX

Compression

101 MB93%126213231169Heavy CPU
Nov 14, 201314.01.0103607f2d382922

.NET ZIP MAX

Compression

202 MB93%110488451195Heavy CPU
Nov 14, 201314.01.0103607f2d382921LZ4152 MB89%81332171582Lower CPU
Nov 14, 201314.01.0103607f2d382922LZ4304 MB89%74726331629Lower CPU
Nov 18, 201314.01.0103607f2d382921LZ4 (64-bit)152 MB89%84320181494Lower CPU
Nov 18, 201314.01.0103607f2d382922LZ4 (64-bit)304 MB89%82655391379Lower CPU

Note strange behavior where 1 stream is much slower than 2 streams running at the same time

* Calculated from: select sum(LEN(MessageDataBytes)) from Message

** Calculated from: select DATEDIFF(ss,(select top 1 ModifiedDateTime from Message order by MessageId), (select top 1 ModifiedDateTime from Message order by MessageId desc))

Test Scenario 2

  1. Chicago Messages - 533 bytes->35782 bytes, 100000 messages, 927MB uncompressed size
  2. Measure time/throughput of Inbound HL7 Device -> QueueDevice (I->Q)
  3. Measure time/throughput of QueueDevice -> Null Device (Q->N)
  4. Clear Queues after each test
DateVersionRev

Simultaneous

Streams

Compression

Type

Compressed Size

MB*

Ratio

I->Q

(sec)

I-Q

m/sec

Q->I

(sec)**

Q-I

m/sec

Notes
Nov 14, 201613.02.07R15d7299b191ce11IONIC ZIP49 MB46%151662761315Heavy CPU
Nov 15, 201313.02.07R15d7299b191ce12IONIC ZIP99 MB46%18011111561282

Heavy CPU

Nov 14, 201314.01.0103607f2d382921

.NET ZIP MAX

Compression

46 MB50%156641323125Heavy CPU
Nov 14, 201314.01.0103607f2d382922

.NET ZIP MAX

Compression

92 MB50%1081852702857Heavy CPU
Nov 14, 201314.01.0103607f2d382921LZ463 MB32%130769323125Lower CPU
Nov 14, 201314.01.0103607f2d382922LZ4126 MB32%992020653076Lower CPU

Note strange behavior where 1 stream is much slower than 2 streams running at the same time

* Calculated from: select sum(LEN(MessageDataBytes)) from Message

** Calculated from: select DATEDIFF(ss,(select top 1 ModifiedDateTime from Message order by MessageId), (select top 1 ModifiedDateTime from Message order by MessageId desc))