Known Issues and Notes

Interoperability UI Performance Issues

Health Connect 2025.2 introduced two changes that bring performance improvements to most use cases: smarter table statistics and enabling BiasQueriesAsOutlier by default. However, there are a small subset of queries that can be slower than before. The following components of the Interoperability user interface have queries that can fall into this subset:

• The Production UI

• The Message Viewer

• The Message Bank Message Viewer

• The Event Log Viewer

• The Business Rule Log Viewer

• The Production Monitor

These user interfaces can be slow when all three of the following conditions are true:

1. There are greater than 15 million entries in the Messages or Event Log table for the given namespace.

2. Some business components have significantly more activity than the others.

3. Activity on the business components is not evenly distributed over time (for example, if large batches of messages are processed in bulk or is some business components rarely see activity).

If your Interoperability user interface has significantly slowed upon upgrade to this version, you cam employ either of the following workarounds:

1. Use the Purge Management Data feature to confirm that the Message and Event Log have fewer that 15 million entries. If so, purge old data as needed to bring the counts down.

2. In any namespace, manually set the following global:

   set ^%SYS("sql","sys","rtpc","planCostThreshold") = 10  
   

   

   This value is undefined by default. If you wish to revert this behavior, kill the global subnode as follows:

   kill ^SYS("sql","sys","rtpc","planCostThreshold")