This option sets the format in which rows are stored. The supported values are:
| Value | Description |
|---|---|
expanded
|
Rows are stored in the machine native format. |
compact
|
Rows are stored in the platform independent compressed format. |
- Compact Format
The compact format option ensures database portability between different hardware architectures (like X86 and PowerPC). If the system design enables hardware using different architectures communicating with each other, the compact setting must be used to correctly communicate database information to and from the TFS.
- Note
- The
compactoption may save a few bytes of storage and communication packet size at the expense of possible performance degradation since all numbers will need to be decoded to use and encoded to store.
- Expanded Format
The expanded format option stores all numbers in the machine native form of the hardware architecture. While this may provide a slight performance improvement in reading values because of the elimination of a decoding step, the expanded format causes the database image to be non-portable.
- Note
- The
expandedoption should only be set if the database will never need portability and performance is affected using thecompactsetting.
- Default Value
If the item_format option is not defined, the default value of compact is used.
- Example
-
item_format=compact
- 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()