Question David Foard · Dec 13, 2021 API Monitor Metrics - KPI recommendations? Is there any recommended KPI's we should be using to monitor our IRIS configurations in Azure? #Monitoring #InterSystems IRIS for Health 0 3 0 220
Question David Foard · Sep 16, 2021 Best practices for IRIS and Kubernetes Does InterSystems have any best practices for deploying IRIS into Kubernetes? For example one question we have is should IRIS have a dedicated AKS cluster or can it be added to an existing cluster? David #Kubernetes #InterSystems IRIS for Health 0 7 0 285
Question David Foard · Aug 20, 2021 IRIS integration with Azure AD Has anyone integrated IRIS with Azure AD? Any tips or guidelines you can provide are appreciated. David #Azure #InterSystems IRIS for Health 2 3 0 203
Question David Foard · Mar 29, 2021 Purge strategy for parent-child persistent objects We are seeing performance issues in purging objects/tables that have parent-child relationships defined. Due to the number of child objects we're seeing very long duration to purge a single parent and all child tables. Is there a better way to do this and get a more performant purge task? I was thinking to purge the child tables individually first and then delete the parent is one way. Is there any other approach? David #InterSystems IRIS for Health 0 1 0 206
Question David Foard · Oct 13, 2020 FQDN ? Is there an undocumented class method that will output the FQDN? $SYSTEM only reports the part of the name concatenated with the namespace. Checking $SYSTEM.INetInfo doesn't provide the full DNS name, only a partial value that matches $SYSTEM. I can do a call out to the OS to get that value which seems to be the only way I can get the value. #InterSystems IRIS for Health 0 4 0 204
Question David Foard · Sep 16, 2020 More than 1 cursor in a class I have a class that has 2 different cursors for different queries, audit1 and audit2. which are in 2 different methods. The first query runs fine, but the second one generates a 102 error. Is there an issue with having more than 1 cursor in a class? Has anyone seen this before? #SQL #InterSystems IRIS for Health 0 2 0 148
Question David Foard · Jun 12, 2020 Question on configuring /api/monitor for SAM I have a couple of questions regarding /api/monitor and configuring it to use with SAM. In our environment we only expose port 443, so even though I define the Web Application to use unauthenticated, SAM is unable to make a connection. Is there any alternatives to get this working? Also, even if there is a way to configure using port 443, unauthenticated access will never fly in our environment. Are there any plans to enhance SAM so it you use OAuth or even mutual TLS? Dave #API #InterSystems IRIS for Health 1 2 0 208
Question David Foard · Mar 10, 2020 VScode load xml and convert to udl Is there a helper class available that will import an XML class and convert the class to UDL? David #VSCode #InterSystems IRIS for Health 0 1 0 551
Question David Foard · Mar 4, 2020 Version of Eclipse for Atelier Will the Atelier plug-in work with newer versions of Eclipse? Photon is getting a bit old and I'd like to use the latest version. One additional question; Does Atelier work with JDK 11? Dave #Atelier 1 1 0 283
Question David Foard · Dec 26, 2019 Performant index on date field Is there a way to get a good performing index on a date field? I have tried various date property indexes and the query plan is always in a pretty high range. Below are query plan result values I have observed: StartDate > '2019-12-01' --cost = 699168 StartDate = '2019-12-21' --cost 70666 StartDate between '2019-12-21' and '2019-21-28' --cost = 492058 The query plans above were for type %TimeStamp. #Indexing #SQL #Caché 0 7 0 329