大网数据广告活动
磁盘与文件系统

Temporary Database Parameters

· 52CE 我爱测

Learn more about: Temporary Database Parameters

Applies to: Windows | Windows Server

Temporary Database Parameters

This topic contains parameters that are used for the temporary database.

JET_paramEnableTempTableVersioning
46

This parameter controls the use of transactions in temporary tables. When this parameter is false, temporary tables will be faster but it will not be possible to rollback any updates made in a transaction.

Label Value
Default Value: True
Type: Boolean
Valid Range: False, True
Scope: Instance
Set After <a href="gg269354(v=exchg.10).md">JetCreateInstance</a>: Yes
Set after <a href="gg294068(v=exchg.10).md">JetInit</a>: No
Affects Physical Layout: No
Affects Reliability: Yes
Affects Performance: Yes
Affects Resources: Yes
Availability: All

JET_paramPageTempDBMin
19

This parameter controls the initial size of the temporary database. The size is in database pages. A size of zero indicates that the default size of an ordinary database should be used.

It is often desirable for small applications to configure the temporary database to be as small as possible. Setting this parameter to 14 will achieve the smallest temporary database possible. Note that one can also entirely eliminate the temporary database by setting JET_paramMaxTemporaryTables to zero.

Label Value
Default Value: 0
Type: Integer
Valid Range: 0 – 2147483647
Scope: Instance
Set After <a href="gg269354(v=exchg.10).md">JetCreateInstance</a>: Yes
Set after <a href="gg294068(v=exchg.10).md">JetInit</a>: No
Affects Physical Layout: Yes
Affects Reliability: No
Affects Performance: Yes
Affects Resources: Yes
Availability: All

JET_paramTempPath
1

This parameter indicates the relative or absolute file system path of the folder or file that will contain the temporary database for the instance. If the path is to a folder that will contain the temporary database then it must be terminated with a backslash character. The temporary database is used to hold volatile data that is generated in the process of handling ESE API info calls, creating indexes, or storing the contents of a temporary table.

Note  If a relative path is specified then it will be relative to the current working directory of the process that hosts the application that is using the database engine.

Label Value
Default Value: "tmp.edb"
Type: Path (string)
Valid Range: 0 – 247 characters
Scope: Instance
Set After <a href="gg269354(v=exchg.10).md">JetCreateInstance</a>: Yes
Set after <a href="gg294068(v=exchg.10).md">JetInit</a>: No
Affects Physical Layout: Yes
Affects Reliability: No
Affects Performance: No
Affects Resources: No
Availability: All

Requirements

Requirement Value
Client Requires Windows Vista, Windows XP, or Windows 2000 Professional.
Server Requires Windows Server 2008, Windows Server 2003, or Windows 2000 Server.
Header Declared in Esent.h.

See Also

Extensible Storage Engine Files
JetCreateInstance
JetInit

Source: Microsoft Learn / Windows Win32 documentation by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / Windows Win32 documentation
适用范围
Windows Win32 API · Source date 04/11/2016
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。