Article Ben Schlanger · Apr 22 27m read

Table Partitioning Demo Tutorial

Table Partitioning Demo

This demo walks you through the new Table Partitioning feature in IRIS SQL, explaining what it does and how it works along the way. We'll only use a few dozen rows to prove the concept, but obviously the capability is focused on datasets many orders of magnitude larger.

If you'd like a shorter, higher-level introduction to Table Partitioning, check out the online learning module Managing Tables with Partitioning in InterSystems IRIS

 

ℹ️ Table Partitioning is included in IRIS 2026.1 as an experimental feature

#InterSystems IRIS #InterSystems IRIS for Health #Data Model #Mapping #Performance #Relational Tables #SQL #System Administration #Tutorial
1
0 64
Article Ben Schlanger · May 7, 2025 4m read

Long Running SQL Queries: a sample exploration

Here at InterSystems, we often deal with massive datasets of structured data. It’s not uncommon to see customers with tables spanning >100 fields and >1 billion rows, each table totaling hundred of GB of data. Now imagine joining two or three of these tables together, with a schema that wasn’t optimized for this specific use case. Just for fun, let’s say you have 10 years worth of EMR data from 20 different hospitals across your state, and you’ve been tasked with finding….

#InterSystems IRIS #Best Practices #Performance #Relational Tables #SQL #Tips & Tricks
3
6 426
Article Ben Schlanger · Mar 15, 2024 4m read

Uncovering Clues by Querying the Interoperability Message tables

When using InterSystems IRIS as an interoperability engine, we all know and love how easy it is to use the Message Viewer to review message traces and see exactly what's going on in your production. When a system is handling millions of messages per day, you may not know exactly where to begin your investigation though.

Over my years supporting IRIS productions, I often find myself investigating things like...

  • What sort of throughput does this workflow have?
  • Where is the bottleneck?
#Ensemble #HealthShare #InterSystems IRIS for Health #Best Practices
4
6 550