Thank you @Benjamin De Boe !
As you described it:  I followed the doc not being aware that it does not apply to Array!

Using a calculated property as you describe is excellent!

¡Hola Comunidad!

Os traemos el cuarto episodio de Data Points, el podcast de InterSystems en inglés. En esta ocasión, charlamos con @Benjamin De Boe, que nos explica algunas de las cosas que podéis hacer para optimizar vuestras consultas SQL en InterSystems IRIS.

Todos hemos oído — tanto de nosotros mismos como de otros — la queja "esto va demasiado lento". Creo que Benjamin ha hecho un gran trabajo revisando todas las cosas en las que os podeis fijar en vuestras consultas en IRIS para descubrir lo que se puede mejorar.


0   0 1






Hey Robert, 

Thanks very much for this.  It looks like I am closer but getting 

[SQLCODE: <-131>:<After Insert trigger failed>]

  [%msg: <21003,Cannot INSERT "NIActivityCode" because number is already used.>]

@Benjamin De Boe - thanks for letting me know its not available, I just figured I had a comma or apostrophe in the wrong place so I would have kept going around in circles.  It does let me INSERT a single row including the ID so yeah perhaps I will just have to do one at a time if I cannot get Roberts solution going

Hi Community,

We're pleased to invite you to join the upcoming InterSystems IRIS 2020.1 Tech Talk: Data Science, ML & Analytics on April 21st at 10:00 AM EDT!

In this first installment of InterSystems IRIS 2020.1 Tech Talks, we put the spotlight on data science, machine learning (ML), and analytics. InterSystems IntegratedMLTM brings automated machine learning to SQL developers. We'll show you how this technology supports feature engineering and chooses the most appropriate ML model for your data, all from the comfort of a SQL interface. We'll also talk about what's new in our open analytics offerings. Finally, we'll share some big news about InterSystems Reports, our "pixel-perfect" reporting option. See how you can now generate beautiful reports and export to PDF, Excel, or HTML.


Última respuesta 22 April 2020
+ 3   1 1


+ 3


In Episode 4 of Data Points, we welcome @Benjamin De Boe to the pod to discuss some of the things you can do to optimize your SQL queries in InterSystems IRIS. We've all heard — either from ourselves or from others — the "this runs too slowly" complaint. I thought Benjamin did a great job walking through many of the things within IRIS you can look at with your queries to see what can be improved.


+ 1   0 2




+ 1


@Benjamin De Boe 

Have you made any progress on this?

We just starting playing around with using Web Data Connectors in Tableau to call APIs into Cache.  



Thanks @Benjamin De Boe 

I believe we are on a high enough version which should cater for this.

w $zv

Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2017.2.2 (Build 865U) Mon Jun 25 2018 10:50:02 EDT