Export (0) Print
Expand All

Temporary Database Parameters

Windows

Last modified: January 09, 2012

Applies to: Windows | Windows Server

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.

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.

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.

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

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

Show:
© 2015 Microsoft