Article Ben Schlanger · May 7 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…. #Performance #Relational Tables #SQL #Tips & Tricks #InterSystems IRIS 7 1 3 95
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... #Best Practices #Ensemble #HealthShare #InterSystems IRIS for Health 9 2 5 373
Question Ben Schlanger · Feb 17, 2017 Notepad++ Language Pack for COS? Does there exist a User Defined Language pack for Caché ObjectScript for use in Notepad++? I'm hoping some friendly developer somewhere may have created one . http://docs.notepad-plus-plus.org/index.php/User_Defined_Language_Files #Development Environment #Tools #ObjectScript #Caché 0 3 0 2K