TEMP_DIR=\path

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++: Connecting to a database
• UltraLite for C/C++: OpenConnection method
• UltraLite for embedded SQL: Connecting to a database
• UltraLite for M-Business Anywhere: Connecting to an UltraLite database
• UltraLite for M-Business Anywhere: openConnection method
• UltraLite.NET: Connecting to a database
• UltraLite.NET: Open method

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

temp_dir=\Temp;