Learning
Documentation
Community
Open Exchange
Global Masters
Certification
Partner Directory
Ideas Portal
Developer Community
Posts
InterSystems Official
Articles
Questions
Announcements
Discussions
Tags
Events
Tech Article Contest
Programming Contest
InterSystems Ideas Contest
Event Calendar
Products
InterSystems IRIS
InterSystems IRIS for Health
HealthShare
TrakCare
Caché
Ensemble
InterSystems Analytics (DeepSee)
InterSystems Text Analytics (iKnow)
Jobs
Job Opportunity
Job Wanted
Members
About
About Us
FAQ
Feedback
Report an Issue
Share an Idea
Code of Conduct
Contact Us
EN
New post
Language
EN
|
ES
PT
JP
CN
FR
EN
New post
Search
All
Top posts
Latest posts
Tags
Type of post
Announcement
Article
Question
Discussion
Search by user posts
Tags
Caché
Developer Community Official
Documentation
Ensemble
Global Masters
Health Connect
HealthShare
InterSystems Ideas Portal
InterSystems IntelliCare
InterSystems IRIS
InterSystems IRIS BI (DeepSee)
InterSystems IRIS for Health
InterSystems Natural Language Processing (NLP, iKnow)
InterSystems Official
InterSystems Reports (Logi)
IRIS contest
Job Opportunity
Job Wanted
Learning Portal
Open Exchange
Other
Partner Directory
Resource Library
Summit
Supply Chain Orchestrator
TrakCare
.NET
Access control
Adaptive Analytics
Alerts
Analytics
Analyzer
Angular
Angular2
API
Apple macOS
Application Server
Artificial Intelligence (AI)
Authentication
AWS
Azure
Backup
Beginner
Best Practices
Big Data
Business Operation
Business Process (BPL)
Business Rules
Business Service
C++
Callout
CaretDev
CCR
Certification
Change Management
ChatGPT
Cloud
Code Golf
Code Snippet
Coding Guidelines
Columnar Storage
Compatibility
Compiler
Containerization
Contest
Continuous Delivery
Continuous Integration
Convergent Analytics
CSP
CSS
CSV
Cubes
Dashboards
Databases
Database Transaction Processing
Data Import and Export
Data Model
DC Feedback
Debugging
Deployment
Developer Community FAQ
Development Environment
DevOps
Digest
Distributed Data Management
Docker
Document Data Model (NoSQL)
DTL
Early Access Program (EAP)
Eclipse
ECP
Embedded Git
Embedded Python
Encryption
Enterprise Message Bank
Error Handling
Events
Failover
FHIR
Field Tests
Framework
Frontend
FTP
Generative AI (GenAI)
George James Software
Git
GitHub
Globals
Global Summit 2016
Global Summit 2017
Global Summit 2018
Global Summit 2019
Global Summit 2022
Global Summit 2023
Global Summit 2024
Google Cloud Platform (GCP)
Graph
High Availability
HL7
HTML
iFind
Indexing
Innovatium
IntegratedML
integration-required
Interoperability
InterSystems API Manager (IAM)
InterSystems Business Solutions and Architectures
InterSystems Demo Games
InterSystems Package Manager (IPM)
IoT
isNewTech
ITvisors
J2 Interactive
Java
JavaScript
JDBC
Journaling
JSON
Key Question
Key Value
Kubernetes
Languages
Large Language Model (LLM)
LDAP
LEAD North, LLC
Listings
Localization
Machine Learning (ML)
Management Portal
Mapping
MDX
Meetup
Message Search
Microservices
Microsoft Windows
Microsoft Windows Server
Mirroring
Monitoring
Multi-model
MultiValue Basic
Namespace
Natural Language Processing
Node.js
OAuth2
Object Data Model
ObjectScript
ODBC
Open Source
OpenVMS
Perforce
Performance
PID^TOO||
Platforms
Podcast
Prompt Engineering
Python
React
READY 2025
Red Hat Enterprise Linux (RHEL)
Relational Tables
Release
REST API
Security
Sharding
SOAP
Source Control
SQL
SSL
Startup
Studio
SVN
Swagger
System Administration
System Alerting and Monitoring (SAM)
Terminal
Testing
Tips & Tricks
Tools
Tutorial
Ubuntu
UI Development
UIMA
Unstructured Data
Vector Search
Video
Virtual Summit 2020
Virtual Summit 2021
Visualization
VSCode
Vue.js
Web Gateway
Webinar
XML
ZEN
Apply
Clear filter
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
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
first
previous
…
62
63
64
65
66
…
next
last
Log in or sign up
Log in or create a new account to continue
Log in
Sign up
Log in or sign up
Log in or create a new account to continue
Log in
Sign up
Log in or sign up
Log in or create a new account to continue
Log in
Sign up
Log in or sign up
Log in or create a new account to continue
Log in
Sign up