Question Jack Rack · Oct 11, 2025 How can I write a custom SQL storage strategy for ObjectScript classes in IRIS? Instead of default storage classes, I want to implement my own SQL storage mapping for a persistent class (e.g., denormalized or sparse matrix structures). How do I define and manage custom storage definitions? #InterSystems IRIS 0 0 0 34
Question Jack Rack · Oct 11, 2025 How can I implement a secure and scalable multi-tenant architecture in IRIS using namespace isolation and role delegation? What are the best practices for creating a multi-tenant app in IRIS? How can I isolate data per tenant using namespaces, control resource usage, and delegate access via roles securely? #InterSystems IRIS 0 1 0 65
Question Jack Rack · Oct 11, 2025 How can I leverage bitmap indexes for performance tuning in a hybrid OLAP/OLTP IRIS workload? We run mixed workloads in IRIS. For analytical queries, are bitmap indexes effective? What are the caveats for concurrent OLTP updates, and how should I maintain bitmap indexes efficiently? #InterSystems IRIS 2 1 0 66
Question Jack Rack · Oct 11, 2025 Can I implement custom stream compression algorithms in IRIS for %Stream.GlobalBinary? For space optimization, we want to apply a domain-specific compression algorithm to binary stream data before writing to %Stream.GlobalBinary. Is it possible to override or extend stream classes to include compression/decompression? #InterSystems IRIS 0 1 0 52
Question Jack Rack · Oct 11, 2025 How can I implement an efficient multi-shard SQL query in an InterSystems IRIS sharded cluster? We are using IRIS with a sharded architecture. Complex SQL queries (with joins, aggregates, and subqueries) are performing slowly. How can I design queries or indexes to optimize distributed execution across shards? #InterSystems IRIS 0 1 0 44
All posts