Search

query cache in case something was happening there but it did not fix this. Can you show the query plan? Usually this issue "shows" when indices are out of sync. Maybe try rebuilding indices. This was indeed the issue, indexes needed to be rebuilt.

are deleted. How can I pull the key & value for the row when it is selected for delete /un-delete? The variable rowData is used a pointer for the row index. I know I'm missing

looking at how far we could push IRIS performance with very fast persistence, efficient indexing, and caching for 100s of queries and joins per second.

administered a specific drug between the years of 2017-2019 to patients who reside outside the state and have one of the following conditions

; Object-Valued Properties [GOOD] Determines indexes to add/update to improve performance To determine which indexes to add or update to improve performance in InterSystems IRIS

than 50% of ICU procedures cannot be trained without real patients and/or medical devices. · Medical device manufacturers have a problem gathering medical staff in one place

, populating it with 1M rows and created an index. Then run several queries, and none of them (even alternate plans) are using parallel. Only when %PARALLEL is forced. Weird.... Parallel

to implement relevant use cases and help users be more productive in their daily tasks. Last week's article discussed the Knowledge Portal, a straightforward tool to browse iKnow indexing

for Health. The sample data we used was generated by the SYNTHEA bulk data generation project (https://synthea.mitre.org/downloads). We will convert 1000 patients from a CSV file to SDA

in the intermediate example, the Analytics server introduces the APP-INDEX database storing the indices, whereas the APP-FACT database only storing the fact and dimension tables

global, by latest index. USER>set sc=##class(%UnitTest.Manager).DebugRunTestCase("", "MyPackage.Tests","","TestAdd

).%ExistsId(%class.Name_"||BPL") { set index = %compiledclass.XDatas.FindObjectId(%class.Name_"||BPL") #; get XDATA as stream set stream

synchronization at the exact same instant (in index meaning) so that no inserts are lost between the database "PERSONADATA2" creation in the primary and the creation in the secondary. Caché

have a comment, please respond through the InterSystems Developer Community, don't send me private email. Unless of course you wish to address me only.See NewBie Index for an index of all NewBie Corner posts

Hi I want to check patient class in multiple rules, since the message structure is different to reach out to patient class value, i created a method to get the patient class