查找 | InterSystems Developer Community

Question

Jack Rack · Oct 11

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?

Discussion (0)0

Question

Jack Rack · Oct 11

#InterSystems IRIS

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?

1 Comment

Discussion (1)1

Question

Jack Rack · Oct 11

#InterSystems IRIS

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?

1 Comment

Discussion (1)1

Question

Jack Rack · Oct 11

#InterSystems IRIS

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?

1 Comment

Discussion (1)1

Question

Jack Rack · Oct 11

#InterSystems IRIS

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?

1 Comment

Discussion (1)1

查找

How can I write a custom SQL storage strategy for ObjectScript classes in IRIS?

How can I implement a secure and scalable multi-tenant architecture in IRIS using namespace isolation and role delegation?

How can I leverage bitmap indexes for performance tuning in a hybrid OLAP/OLTP IRIS workload?

Can I implement custom stream compression algorithms in IRIS for %Stream.GlobalBinary?

How can I implement an efficient multi-shard SQL query in an InterSystems IRIS sharded cluster?