Encontrar

Question

Jack Rack · Oct 11

Can the IRIS SQL engine be extended with custom optimization rules (e.g., prioritizing certain indices or join orders)? If not, is there a supported way to influence cost models?

Discussion (0)0

Question

Jack Rack · Oct 11

#InterSystems IRIS

We’re encountering occasional deadlocks when accessing persistent objects. How can I trace lock acquisition and identify cyclic dependencies in real time?

1 Comment

Discussion (1)1

Question

Jack Rack · Oct 11

#InterSystems IRIS

We want to expose both REST and GraphQL endpoints over the same data models. Is there a way to implement or integrate GraphQL with ObjectScript and map to class methods?

1 Comment

Discussion (1)1

Question

Jack Rack · Oct 11

#InterSystems IRIS

I need to ingest streaming data over WebSockets. How can I create a custom inbound adapter for IRIS productions that supports many concurrent socket connections?

1 Comment

Discussion (1)1

Question

Jack Rack · Oct 11

#InterSystems IRIS

I have large joins involving millions of rows. How can I profile and tune the SQL engine’s parallel execution? Are there EXPLAIN plan features to inspect threading and task distribution?

1 Comment

Discussion (1)1

How do I build a custom cost-based query optimizer rule in IRIS SQL engine?

How do I trace IRIS internal locking behavior for debugging deadlocks in object transactions?

How can I create a hybrid REST and GraphQL API layer over IRIS data using ObjectScript?

How can I write an IRIS interoperability adapter for high-throughput WebSocket connections?

How do I analyze and tune parallel query execution in IRIS SQL engine for complex joins?