RESERVE_SIZE= number{ k | m | g }

0 (no reserve size).

The value you supply can be any value from 0 to your maximum database size. Use k, m, or g to specify units of kilobytes, megabytes, or gigabytes, respectively. If you do not specify a unit, bytes are assumed by default.

You should run the database with test data and observe the database size and choose a reserve size that suits your UltraLite deployment.

If the RESERVE_SIZE value is smaller than the database size, UltraLite ignores the parameter.

Reserving file system space can improve performance slightly because it may:

Because an UltraLite database consists of data and metadata, the database size grows only when required (when the application updates the database).

• Opening UltraLite connections with connection strings
• UltraLite CACHE_SIZE connection parameter
• UltraLite page_size creation parameter
• 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 sets the reserve size to 128 KB so the system reserves that much system space for the database upon startup.

"RESERVE_SIZE=128K"