db_size

This is the total size threshold the database engine tries to enforce for the .pack files in the database subdirectory. When the total size exceeds this value, the system will force vacuuming to free up space occupied by unused space in pack files. Performance will constantly be degraded when the database is exceeding the maximum because the system will is forced to vacuum all files in order to eliminate vacuumed files in the middle of a sequence of .pack files.

Note

This value should be at least pack_file_size bytes less than the space allocated for the database storage. The database can continue to grow larger than db_size but will constantly be vacuuming in an attempt to see if free space in the database can be found.

Default Value

If the db_size option is not defined, the default value of 21474836480 is used.

Example

db_size=21474836480

Database Configuration Options

This option key is associated with the RDM_DB handle (or RDM_CPP::Db for C++) and can be set using one of the following functions:

• SQLSetConnectAttr()
• rdm_dbSetOption()
• rdm_dbSetOptions()
• RDM_CPP::Db::SetOption()
• RDM_CPP::Db::SetOptions()

The option key can also be associated with the RDM_TFS handle (or RDM_CPP::TFS for C++) which will be inherited by the next RDM_DB handle (or RDM_CPP::Db for C++) allocated. Modifications to the RDM_TFS after the RDM_DB is allocated have no effect on the allocated RDM_DB. The following functions can be used to set the key/values to be inherited later:

• rdm_tfsSetOptions()
• rdm_tfsSetOption()
• RDM_CPP::TFS::SetOption()
• RDM_CPP::TFS::SetOptions()

See also

vacuuming