| title | Caching Templates, XSL, and Schemas (SQLXML) | |||
|---|---|---|---|---|
| ms.date | 03/14/2017 | |||
| ms.prod | sql | |||
| ms.prod_service | database-engine, sql-database | |||
| ms.reviewer | ||||
| ms.technology | xml | |||
| ms.topic | reference | |||
| helpviewer_keywords |
|
|||
| ms.assetid | 80b4fa79-243f-442c-9f22-74ad66186501 | |||
| author | MightyPen | |||
| ms.author | genemi | |||
| ms.custom | seo-lt-2019 | |||
| monikerRange | =azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md] To improve performance, [!INCLUDEmsCoName] SQLXML 4.0 supports caching templates, XSL, and schemas.
All schemas, templates, and XSL files (except the files from an https:// 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.
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.