HL7 Soup Desktop · 39-second tip
Open 25 million HL7 messages in 15 seconds
Watch HL7 Soup Desktop open a 5.79 GB file, browse millions of rows, count field values, and filter to discharges.
Watch on YouTubeRead the transcript
Try it yourself
- Open a file containing 25 million HL7 messages.
- Browse the message list and open a message 17 million rows down.
- Select the trigger event field to count its values in Statistics.
- Double-click A03 to filter to 3,749,527 discharges.
Recorded on a Mac mini with 16 GB of memory. Opening the file took 15.2 seconds; opening a message 17 million rows down took 1.6 seconds; Statistics took 10.8 seconds; filtering took 15.6 seconds. The waits are sped up in the video, with a stopwatch showing the actual elapsed time.
Video transcript
0:0025 million HL7 messages, in one file of almost 6 GB. Watch HL7 Soup Desktop open it. 15 seconds, and all 25 million are ready.
0:12Drag through the millions, and open any message, instantly.
0:18Click a field, and Statistics counts every value across all 25 million. Double-click A03 to filter, and you're down to 3.7 million discharges.
0:32HL7 Soup Desktop. Try it free for 30 days.
Music: “Easy Lemon” by Kevin MacLeod (incompetech.com), licensed under Creative Commons Attribution 4.0.