We are seeing performance issues in purging objects/tables that have parent-child relationships defined. Due to the number of child objects we're seeing very long duration to purge a single parent and all child tables. Is there a better way to do this and get a more performant purge task? I was thinking to purge the child tables individually first and then delete the parent is one way. Is there any other approach?



0 1 95
David Foard · Oct 13, 2020

Is there an undocumented class method that will output the FQDN?

$SYSTEM only reports the part of the name concatenated with the namespace. Checking $SYSTEM.INetInfo doesn't provide the full DNS name, only a partial value that matches $SYSTEM.

I can do a call out to the OS to get that value which seems to be the only way I can get the value.


0 4 139
David Foard · Sep 16, 2020
More than 1 cursor in a class

I have a class that has 2 different cursors for different queries, audit1 and audit2. which are in 2 different methods. The first query runs fine, but the second one generates a 102 error.


Is there an issue with having more than 1 cursor in a class?

Has anyone seen this before?

0 2 91

I have a couple of questions regarding /api/monitor and configuring it to use with SAM. In our environment we only expose port 443, so even though I define the Web Application to use unauthenticated, SAM is unable to make a connection. Is there any alternatives to get this working?

Also, even if  there is a way to configure using port 443, unauthenticated access will never fly in our environment. Are there any plans to enhance SAM so it you use OAuth or even mutual TLS?



0 2 128
David Foard · Dec 26, 2019
Performant index on date field

Is there a way to get a good performing index on a date field? I have tried various date property indexes and the query plan is always in a pretty high range. Below are query plan result values I have observed:

   StartDate > '2019-12-01'  --cost = 699168
   StartDate = '2019-12-21'  --cost 70666
   StartDate between '2019-12-21' and '2019-21-28' --cost = 492058


The query plans above were for type %TimeStamp.




0 7 203
David Foard · Nov 15, 2019
Question on sharding

Prior to IRIS, using ECP to share databases under heavy I/O load has known latency issues (in our environment), which pretty much restricted using shared database with relatively static or slow-changing data. In IRIS, will sharding mitigate the latency issue and allow any table to be shared?



0 2 132

Is %CSP.BinaryStream compatible with %StreamGlobalBinary because reviewing the classes this doesn't look to be the case?

What I am trying to do is zip large documents before sending over a REST interface. I compress the file and add that to an Ens.StreamContainer which is then passed to the operation to build the REST payload. We are using %Net.MimePart class to build the payload and use the BodySet method to add the zipped Ens.StreamContainer.

The issue is when the REST interface receives the POST, it doesn't recognize the data as a zip compressed item.


0 1 122