Purpose
This table is used to cache exploded XML fragments for Instance records that are often used but rarely change.
The most common (but not only) use case is the caching of Form Definitions. In production, Form Definitions are complex and rarely change. The Dynamic Page Builder uses the DeepXML process to explode the Form Definition down through all of its children including Rows, States, Events, Fields. Commands, etc. The exploded XML is then cached so that it isn’t constantly being recreated.
Definition
CREATE TABLE [dbo].[DeepXML](
[InstanceGUID] [UNIQUEIDENTIFIER] NOT NULL,
[DeepXML] [VARCHAR](MAX) NOT NULL,
CONSTRAINT [PK_DeepXML] PRIMARY KEY CLUSTERED
(
[InstanceGUID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
Column Definition
The InstanceGUID identifies the Instance record at the top of the expanded hierarchy.
The DeepXML contains the complete XML fragment including all of its child elements.