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. |