User bio

I started in InterSystems in April 2012 and spent nearly 8 years in Support before moving in Sales Engineering.  I consider myself a generalist professionally and personally.  I dabble in everything and have a passion understanding how things work together.

Member since May 17, 2016


The scenario that I can hypothesize that would produce these results are around the client timing out before the query finishes executing on the server. 

Query 1 fails because you have to do a join on the two large tables and your only where clause is against a property that is not indexed.

Query 2 succeeds because object IDs are "indices by nature".

Query 3(from your comment) succeeds because you are filtering out hundreds, thousands, maybe millions of Ens.MessageHeader objects in your join by using a where clause against and indexed MessageBodyClassName property.

I would recommend reaching out to InterSystems WRC to review the query cost and overall performance to confirm or dive deeper into the failures.

Certifications & Credly badges:
Jeff has no Certifications & Credly badges yet.
Global Masters badges:
Jeff has no Global Masters badges yet.
Jeff has not followed anybody yet.