查找

Pergunta
· Out. 11

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

#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
Discussão (1)1
Entre ou crie uma conta para continuar
Pergunta
· Out. 11

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

#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
Discussão (1)1
Entre ou crie uma conta para continuar
Pergunta
· Out. 11

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

#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?

Discussão (0)0
Entre ou crie uma conta para continuar
Pergunta
· Out. 11

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

#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
Discussão (2)1
Entre ou crie uma conta para continuar
Pergunta
· Out. 11

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

#InterSystems 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?

Discussão (0)0
Entre ou crie uma conta para continuar