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 JetCreateInstance:	Yes
Set after JetInit:	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 JetCreateInstance:	Yes
Set after JetInit:	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 JetCreateInstance:	Yes
Set after JetInit:	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