Search

Clear filter
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

: 🏅 4th place: iris-image-index-demo by @José.Pereira 🏅 5th place: Terminal Multi-Line Command Editor​​​​ by @Robert.Cemper1003 🏅 6th place: Dictionary
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
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
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
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
Scott Roth · May 15, 2023

Linked Table connection through JDBC

a ticket open with WRC and started a chat on Discord. We have a couple of MS SQL tables that I have setup as Linked Tables within Cache to query NPI, Patient Account Information, Visit
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
Question
Lawrence Grace · Sep 12, 2019

How to use Rest API in DeepSee

and build your cube, which will create a fact table (and several other tables) to store an indexed copy of the data you have specified. There is documentation on defining cube
Question
Evgeny Shvarov · Oct 21, 2022

What is The Global With Persistence Data For A Class

the USEEXTENTSET parameter to specify shorter and more efficient hashed global names for data and index lookup operations. You can use %Library.CompiledStorage to find out what the global name
Question
JOSEPH MONEY · Sep 14, 2021

Do Views Speed up query response time

on Server 3... If the creation of a view doesn't assist in anyway to query execution then it doesn't matter and it all comes down to indexes I guess but I don't have permission to create
Question
Elliott Grey · May 10, 2023

Sort array of version numbers in ObjectScript

has no idea of ObjectScriptnonexisting methods, wrong indexing, ...... DISAPPOINTING Thank you so much!
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
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