Disable sql auto-tune in IRIS 2022.1
Hello,
Do you know if there is any way to disable the automatic tuning IRIS is doing every time a class is altered? It just takes too long in our case and is holding the system, so I'd like to tune the tables when I decide it (again).
I've seen in the documentation that for 2023 version there is an option present in the backend. But not for 2022, so I assume a flag is needed somewhere.
Many thanks!
Product version: IRIS 2022.1
$ZV: IRIS for Windows (x86-64) 2022.1.2 (Build 574U) Fri Jan 13 2023 15:00:26 EST
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
go into the terminal and the namespace you want to disable, then type Set ^%SYS("sql","sys","autotune") = 0
I've always wanted my Zen tablePane (T-Pain, as we call them for short) to be able to use autotune. So glad this is finally possible in 2022.1. Brings me back to the golden days in the late '00s where we did lots of things that seemed really cool at the time and feel kind of silly now.