caching-templates-xsl-and-schemas-sqlxml-4-0.md

title	Caching Templates, XSL, and Schemas (SQLXML 4.0) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	dbe-xml
ms.tgt_pltfrm
ms.topic	reference
helpviewer_keywords	SQLXML, caching cache [SQLXML] memory [SQLXML]
ms.assetid	80b4fa79-243f-442c-9f22-74ad66186501
caps.latest.revision	25
author	douglaslMS
ms.author	douglasl
manager	jhubbard

Caching Templates, XSL, and Schemas (SQLXML 4.0)

To improve performance, [!INCLUDEmsCoName] SQLXML 4.0 supports caching templates, XSL, and schemas.

All schemas, templates, and XSL files (except the files from an http:// or ftp:// location) are cached. The cached files remain in memory while the process is running. As the process exits, all the cache is lost. Therefore, if you run one process per query, the caching benefit may not be noticeable.

The topics in this section provide more information about caching.

In This Section

Template Caching (SQLXML 4.0)
Describes and provides a registry key for template caching.

XSL Caching (SQLXML 4.0)
Describes and provides a registry key for XSL caching.

Schema Caching (SQLXML 4.0)
Discusses SQLXML side-by-side installation issues related to schema caching, and provides registry keys for schema caching.