Search

Clear filter
Announcement
Vadim Aniskin · Jan 17, 2024

Top InterSystems Ideas Contributors for 2023

Cloud @wang.zhe 14 Most Commented Ideas: Idea Author Comments Binary index implementation @Akio.Hashimoto1419 14 testing dashboard for InterSystems IRIS
Question
Nezla · Apr 10, 2022

SQL query confusion

. In this case, you should ignore host variables. Host Variables You can also try rebuilding the Index Table or clearing Cached Queries. Portal uses cached query and in its code it uses
Question
Ephraim Malane · Oct 13, 2022

How to convert xlsx to csv

[ Language = python ] { import pandas as pd read_file = pd.read_excel(source) read_file.to_csv(source+'.csv', index = None, header=True) } FYI, the reason this is so difficult
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
Question
Jeff Harris · Jul 8, 2020

Ensemble - How do I change the order in which addenda segments appear in the OBX

where a new Addenda begins and ends, and it also very happily creates a numbered index for me. Clearly being new to DTL, is it possible to feed the content from OBX|1| and OBX|2