Find

Question

Jack Rack · Oct 11

We require user-specific row access (row-level security). How can we enforce this in SQL and ObjectScript using custom class parameters and dynamic WHERE clause injections?

2 Comments

Discussion (2)1

Question

Jack Rack · Oct 11

#InterSystems IRIS

When writing dynamic SQL queries using embedded SQL, how can I force or ensure that filter conditions are pushed down to the data access layer rather than evaluated in memory?

1 Comment

Discussion (1)1

Question

Jack Rack · Oct 11

#InterSystems IRIS

We’re ingesting high-volume HL7 messages and converting them to FHIR in near-real-time. How do we design a streaming ETL pipeline using interoperability (productions) that scales horizontally?

1 Comment

Discussion (1)1

Question

Jack Rack · Oct 11

#InterSystems IRIS

I’m using recursive CTEs for hierarchical data, but the planner seems to produce inefficient plans. Can I influence or extend the query optimizer behavior in IRIS?

Discussion (0)0

Question

Jack Rack · Oct 11

#InterSystems IRIS

We want to iterate over large global structures in real-time without blocking or locking readers. How can we safely use $Order() and implement a lock-free analytics approach?

2 Comments

Discussion (2)1

Can I implement row-level security in InterSystems IRIS using class parameters and runtime filters?

How do I perform predicate pushdown optimization in IRIS embedded SQL with dynamic joins? Body:

How do I stream process and ETL terabyte-scale HL7/FHIR data using InterSystems IRIS Interoperability?

Can I customize the IRIS SQL query planner to optimize recursive CTE execution?

How can I use $Order() traversal with lock-free concurrency for real-time analytics in IRIS?