TEMP_DIR=\path

In addition to the database file, UltraLite creates and maintains a temporary file during database operation. You do not need to work with or maintain the file in any way.

By default, UltraLite maintains its temporary file in the same folder (if one exists) as the UltraLite database itself. The temporary file has the same file name as the database, but for file-based platforms the tilde is included in the extension of the file. For example, if you run the CustDB.udb sample database, the temporary file called CustDB.~db is maintained in the same directory as the database file.

Specifying a temporary directory with faster I/O characteristics can improve the performance of things like temporary tables which are large relative to the cache size. Long-running transactions can also consume noticeable space in the temp file.

Paths with spaces require quotes. Otherwise, the client returns SQLE_UNABLE_TO_CONNECT_OR_START.

• UltraLite for C/C++: UltraLite database connections
• ULDatabaseManager.OpenConnection method [UltraLite C++]
• UltraLite for embedded SQL: UltraLite database connection using embedded SQL
• UltraLite.NET: Connection setup for an UltraLite database
• ULConnection.Open method [UltraLite.NET]

The following connection string fragment puts the temp file in the \Temp directory:

temp_dir=\Temp;