Question Stefan Schick · Nov 8, 2022 Howto perform tune table in a readonly database (Message Bank) Hello, searching messages in our Message Bank is quite slow, often runs into timeout. I wanted to perform a tune table on Ens_Enterprise_MsgBank.MessageHeader because this apparently has not been done yet - the Tune Table utility shows no entries for selectivity, etc. I tried w $SYSTEM.SQL.Stats.Table.GatherTableStats("""Ens_Enterprise_MsgBank"".MessageHeader") and got this error message #Databases #Enterprise Message Bank #Message Search #SQL #InterSystems IRIS for Health 1 6 1 385
Question Stefan Schick · Jul 20, 2022 Howto disable journaling temporarily for one database Hello everyone, I want to restore a database from an external backup with the journal files. The manual says I should (in short): #Backup #Databases #Journaling #InterSystems IRIS for Health 0 6 0 464
Question Stefan Schick · Mar 24, 2022 Howto add / remove searchtable items Hello, I'd like to add/remove items to/from a custom HL7 searchtable (which extends EnsLib.HL7.SearchTable). Adding new items worked fine by: -add new item to class definition compile class in all namespaces reindexing messages with the BuildIndex() method Question 1: #HL7 #Message Search #InterSystems IRIS for Health 0 3 0 286