Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite database reference » UltraLite connection parameters

UltraLite TEMP_DIR connection parameter

Specifies the name of the directory (which must already exist) into which UltraLite will place the temporary file (with a name derived from the database name).


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.


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