SQL adaptive mode s not avail. on 2022.1.2 but only on 2023.1 (right)

%SYS>s Status=##Class(Config.SQL).Get(.Properties)
%SYS>zw Properties
Properties("ANSIPrecedence")=1
Properties("AdaptiveMode")=1
... 
Properties("TimePrecision")=0

all headers are stored in the %request.CgiEnvs("HTTP"_xxxxx)

You may do something like this in the OnPreHTTP method in your CSP page:

if you encounter another situation that you cannot add a space before the # you can do:

Very good article, Yuri.

Wonder when Intersystems will support AMQP protocol, to integrate seamlessly with ASB (Azure Service Bus)

Hello,

If the database that you copy/import routines is journaled, and changes to routines source (^ROUTINE) and compiled code (^rOBJ) will also exist in the journal files. There is also a ^rBACKUP but it is not relay holding old versions of routines (for this you will have to use wither studio-hooks or GIT) 

90 min. to 1M records is very low.
It seems that the query is scanning at one of your big tables (Records maybe).
Do you have indices on: Records.qw and on Records.er
Consider to run the query in %parallel mode, after you optimize it.

How exactly are you counting, Robert? to me it looks shorter than the previous one

Class codeGolf.Pyramid
{

ClassMethod Build(f As %Integer)
{
    F i=1:1:f K s,c S ($P(s," ",f-i+1),$P(c,"#",i*2))="" W s,c,!
}

}

Read this: CSP Session Management | Using Caché Server Pages (CSP) | Caché & Ensemble 2018.1.4 – 2018.1.7 (intersystems.com) - look at "Session Timeout" 

Yes the arbiter was unable to communicate. It looks like a network issue.
I recommend you to open a WRC for that 

Usually what matters on "big globals" is the capacity (and compression) on disk.
For that, you may use:
Set sc=##class(%GlobalEdit).GetGlobalSize(directory , GlobalName , .Allocated , .Used)

%Library.GlobalEdit - InterSystems IRIS Data Platform 2022.2 - including private class members
 

Hello,

Basically, a namespace is a "logical" place that can have it's data from more than 1 database.

You have namespace1 binded to database1.
When you create a new namespace2 (binded to database2) and then create a "global mapping" for namespace2 to point for your specific globals from database1

Happy new year Udo.

And many thanks and wishes to all the great community members that makes this place one of the best to acquire and share Intersystems technology knowledge.  

Hello,

I have done a CSP page that allows to measure timings. This shows that using a delimited string, is somehow "a slight" faster than using a list.

Running 10,000,000 iterations on the following code gives:
 

I see that all your TLS/SSL configurations are Client type.
Usually, there is no need to point to the certificate, unless the "client will be asked to authenticate itself".
You should go into each of your configurations, to check if this option is enabled/used. If so, then you will have to update the: "File containing this client's certificate" with the new pem file

Hello Paul,

The compression is using "zstd" type of compression, comming from %occStream.inc 
The function that is used is: $System.Util.Compress(%data,"zstd")
 

I would open a WRC on that since it looks like a pure bug in the SQL compiler