New in InterSystems IRIS 2023.3

Time Series Forecasting Support in IntegratedML

The capability to create time series models with IntegratedML, introduced with InterSystems IRIS 2023.2 as an experimental feature, is now fully supported for production use.

Journal Archiving

Starting with this release, system administrators can now configure an archive location for completed journal files. When configured, after a journal file switch, the completed journal file will first be compressed (using the Journal Compression feature) and then automatically moved to this archive location, which can be on a lower-cost storage tier, such as HDD drives, or cloud storage, such as Amazon S3. Archived journal files can then be automatically deleted from the local journal directory, reducing the overall footprint on the high-performance storage tier used for writing journal files and lowering the total cost of ownership for InterSystems IRIS deployments.

Faster Global Size Estimates

This release introduces a new algorithm for fast estimation of the total size of a global that uses stochastic sampling rather than a block scan. The new algorithm provides accurate estimates (within five percent of the actual size) in seconds for globals that take up hundreds of gigabytes of space. It is available as an option in the ^%GSIZE, %GlobalEdit, and %GlobalQuery interfaces.

Faster ObjectScript Runtime

When using public variables in an ObjectScript routine, the InterSystems IRIS kernel needs them to be registered in an in-memory symbol table that is specific to the routine. Starting with InterSystems IRIS 2023.3, this symbol table is built lazily, only adding public variables upon their first reference. This means only variables actually used in the routine are added to the symbol table, which may significantly reduce the cost of building it. This is an entirely transparent change to internal memory management, but it may yield noticeable performance gains for ObjectScript code that makes significant use of public variables.

TLS 1.3 Support Update for Windows (OpenSSL 3.1.1)

With this version, the Windows kit now installs the OpenSSL 3.1.1 library.

OpenSSL 3.0 for AIX

InterSystems IRIS now supports OpenSSL 3.0 on AIX 7.2 and 7.3 via the aixopenssl30 kit. This kit has, as prerequisites, the latest Tech Level for either AIX 7.2 and 7.3.

CentOS

InterSystems no longer supports InterSystems IRIS on CentOS. InterSystems encourages developers who had been using CentOS to switch Red Hat’s free developer program.

VxFS

InterSystems no longer list VxFS as a supported filesystem. InterSystems recommends that SUSE customers on VxFS migrate to XFS or one of the other supported filesystems.

Change to Automatic Freezing of SQL Query Plans

Before this release, InterSystems IRIS would automatically freeze query plans upon upgrading to a new major version, in order to ensure existing plans and performance were maintained. This meant administrators had to manually unfreeze plans in order to benefit from IRIS SQL enhancements in the new release that would lead to a better plan. Starting with InterSystems IRIS 2023.3, when Adaptive Mode is enabled, query plans will no longer be frozen automatically, but invalidated upon upgrade so they get re-planned upon their first invocation after upgrading. For more details, see the corresponding documentation.

General Enhancements to InterSystems SQL

This release introduces a number of general enhancements to IRIS SQL:

• Various performance improvements when querying tables using columnar storage, including operators such as IN and JOIN, various functions, and general data access patterns

• Various performance improvements for query statements involving date/time functions

• Several enhancements to the experimental Foreign Tables capability introduced in 2023.1

• Expanded support for Adaptive Parallel Execution to additional query types, increasing throughput for large queries

• The Statement Index now also tracks DDL statements, in addition to DML and query statements