Rechercher

Pergunta
· Abr. 10

Is there a way to reduce IRIS 2024.3 memory usage during heavy query load?

#Outro

Hi everyone,


I'm currently testing out IRIS 2024.3 for a new project, and it's been running smooth for the most part. However, I noticed that when running some heavier analytical queries, the memory usage spikes more than I expected, even when result sets aren’t that large.

I’ve gone through the basics (buffer sizes, query plans, etc.), but I’m wondering if there are any new tweaks or recommended settings in 2024.3 specifically for managing memory better during these peak loads.

Anyone else run into something similar or have tips to fine-tune this?

Thanks for any help!
 

 
.
1 Comment
Discussão (1)1
Entre ou crie uma conta para continuar
Pergunta
· Abr. 9

Business Rule Editor - Using Foreach Action and how to account for the counter

#Regras do negócio #HL7 #HealthShare #InterSystems IRIS for Health #Health Connect

I have a segment within a Group (grp) that needs to be validated that it is populated within the message. 

When you use a Foreach within a Business Rule how should you account for the counter in the group?

For example, Epic sends their MFN message in the following format.

MSH~MFI~[~{~MFE~STF~PRA~[~ZPR~]~[~ZLK~]~[~CER~]~[~ZMG~]~[~ZTF~]~[~ZGP~]~[~ZDD~]~}~]

so, the ZLK segment might not exist until the last MFEgrp that is in the message. I need to verify if there is an Employee ID associated with the Provider in the HL7 message before I run it through the translation.

1 Comment
Discussão (1)1
Entre ou crie uma conta para continuar
Anúncio
· Abr. 9

[Video] Introduction to OMOP Platform

#FHIR #HL7 #Vídeo #InterSystems IRIS for Health

Hey Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ Introduction to OMOP Platform

This video introduces the OMOP Platform, a new service by InterSystems designed to support researchers by transforming EHR data into the OMOP format. The platform features a FHIR-to-OMOP transformation pipeline and an OMOP repository hosted on Intersystems IRIS Cloud SQL. It automates data mapping, terminology mapping, and error reporting, processing bulk FHIR data from an S3 bucket. The platform simplifies data conversion and access without requiring coding expertise.

🗣  Presenter: @Qi Li, Physician Executive, InterSystems

Enjoy watching, and look for more videos! 👍

Discussão (0)1
Entre ou crie uma conta para continuar
Resumo
· Abr. 9

InterSystems Community Q&A Monthly Newsletter #47

#Developer Community Oficial #Resumo
Top new questions
Can you answer these questions?
#InterSystems IRIS
Question about varstrings
By Alan Decourtray
Java Server timing out
By john.smith4237
GENERATE JWT / OAUTH2.0 SIGNATURE
By Sanjib Pandey
2 [Utility.Event] ISCLOG: WebSocket [SendAsyncMessage]
By Lucas Galdino
irisowner getting in the way of irisusr when using $ZF(-100)
By Mauricio Aguirre
comparison library with renderers in IRIS, similar to Python's difflib ("Helpers for computing deltas")
By Mauricio Sthandier
One property crashes IRIS query
By Jerry Petrole
AWS Files
By Touggourt
Validate XML message against XSD schema
By José Francisco Jodar
S3
By Touggourt
VSCode - trying to use tag to call SELECT statement
By Scott Roth
Best Practices for Git Integration with Developer Namespaces in IRIS
By Alex Efa
git-source-control questions
By Fiona Griffiths
IRIS Terminal remote connection
By Touggourt
SLF4J error
By john.smith4237
How to create a custom scheduler
By Saman Marasinghe
How to use class property ot type %Persistent in non persistent class (page)
By PagerianDevelper
"Bad value for type long" on select from PostgreSQL via EnsLib.SQL.OutboundAdapter
By Andrew Sklyarov
Convert HTML to PDF
By john.smith4237
%NOCHECK for Objects
By Matthew Giesmann
"garbled text" due to incorrect character encoding or decoding.
By Fahima Ansari
#Other
#HealthShare
#InterSystems IRIS for Health
#Caché
#47Monthly Q&A fromInterSystems Developers
Pergunta
· Abr. 9

One property crashes IRIS query

#Caché #InterSystems IRIS

Hello, 

One of our clients has a 'Notes' class with over 3 million records.   We have a report that pulls data from this table that was taking about an hour to run.   Our test environment (which has a copy of the production database) runs the same report query in 1 second.    

We attempted to purge and rebuild indices which made an improvement (down to 15 minutes) but still not great.

Next we ran tune table through the Mgmt Portal and it timed out.    I then ran tune table via the Terminal and it finished in a couple minutes.   Suddenly our application was hanging anywhere this table was referenced.    We realized there was one boolean property in the WHERE clause causing the problem.   Our only recourse was to remove the offending property from the WHERE clause and filter on that value within the code loop instead.      That works fine but we'd still like to know what is going on.    Has anyone seen behavior like this and if so how did you deal with it?   Thanks very much!!

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