Search

Clear filter
Announcement
Anastasia Dyubaylo · Feb 5, 2024

Winners of InterSystems FHIR and Digital Health Interoperability Contest

to the fhirmessageverification app by @珊珊.喻 🌟 $100 go to the Clinical Mindmap Viewer app by @Yuri.Gomes 🌟 $100 go to the Patient-PSI-Data app by @Chang.Dao
Article
Robert Cemper · Jan 2, 2022

DB Migration using SQLgateway

edit and Test Connection - verify Connection successful - Be patient at this point. Postgres Containers sometimes take quite some time to talk to you. - Wait a little
Article
Robert Cemper · Jan 30, 2022

My Reviews on Open Exchange - Jan.2022

4 dataset-finance clean and and complete exercise 5.0 y 5 Health Dataset nice DB for 270 anonymous patients 5.0 y 6 objectscript-json-patch excellent
Article
Dmitry Maslennikov · Jul 2, 2023

Profile ObjectScript with more power

patients. This uncovers some interesting discoveries, like, about 40% of the time is spent on IndexResource And about 20% to ValidateResource Of course, this can't be very accurate
Article
Robert Cemper · Aug 26, 2017

From The Roots to InterSystems

persistent data could easily take 30%+ of your available memory and no idea if sorting, indexing, .... No strong data types anymore or data types imposed by names (ALGOL, FORTRAN
Article
Peter Cooper · May 11, 2018

Replacing ZEN - Part 3 - Progress to date 01

Index to Articles Hi All It's been 6 weeks since my original article - - - - -but I have been busy on this project I have been looking at/thinking about a replacement
Article
Matthew Giesmann · Nov 8, 2016

Introduction to Outlier Selectivity

indexes, 90% vs. 3% of a table can make a big performance difference and can again change which query plan the SQL engine chooses. # Queries with Outlier Selectivity Outlier
Question
Jose Antonio Cañizares · Jul 14, 2017

Is there a way to map a $lb() to its data model

positioning to match their $list index according to their property definition index. But you will need to describe each property to detect their types and if they are instantiable. In case
Question
Nael Nasereldeen · Dec 10, 2019

Using %JSON.Adaptor to Export Complex Objects with relationships of 'many to many' type

, %JSON.Adaptor, %Populate){ Relationship Student As TafnitTest.Student [ Cardinality = one, Inverse = Teachers ]; Index StudentIndex On Student; Relationship Tracher As TafnitTest.Teacher
Announcement
Anastasia Dyubaylo · Mar 8, 2021

InterSystems Grand Prix Contest: CONGRATS THE WINNERS

place: iris-image-index-demo by @José.Pereira 🏅 5th place: Terminal Multi-Line Command Editor​​​​ by @Robert.Cemper1003 🏅 6th place: Dictionary comparison
Question
Yone Moreno · Aug 4, 2021

Convert a %String property with CDATA and XML content to Ensemble object

contador= tResultList.Count() /// ¿Por qué sale contrador = 0? $$$LOGINFO("contador es: "_contador) if (contador>0){ for index=1:1:tResultList.Count
Article
Evgeniy Potapov · May 20, 2022

How we reduced the report generation time by 28 times

such a table to be a big one.What was the size (in GB) of the underlining global? Based on it looks like History.Views may not have indices or at least doesn't have a bitmap index
Question
Evgeny Shvarov · May 29, 2017

Globals vs Locals: What Is Faster

Hi, colleagues!Consider you need to put some (less than 1GB) data to an indexed array and do some data manipulations and calculations with it.Should I prefer global or local
Question
Tuan Minh Do · Jul 16, 2018

%DOC with DeepSee

have data, you need to populate the associated index. A quick and dirty way to do this is an SQL query like the following: update ISC_DM.Fitabase1 set %Doc = %Doc I'm
Question
CM Wang · Jul 18, 2017

How to dynamically change the entry defined in SQL storage map

for this ? <SQLMap name="Index"><BlockCount> ^Blk</BlockCount></SQLMap> set Blks = $lb(-100,-200,-300) for r = 1:1:$ll(Blks){set ^Blk = $li(Blks,r)do