Buffering Simple-Large-Object Data Types

TEXT and BYTE data types pass through the buffer pool if the table is a logging table.

For SELECT, INSERT, UPDATE, and DELETE operations, the database server writes TEXT and BYTE data to disk pages in a dbspace in the same way that it writes any other data type. For more information, refer to Flushing Data to Disk.

When you load with external tables, the TEXT and BYTE data can be in two different formats:

• Informix internal format

  For Informix internal format, the database server places simple large objects after the row rather than in it.

• Delimited format

  For delimited format, the simple large objects are embedded within the row. When loaded from a pipe, the data might be staged to a temporary area on disk because it does not fit into the buffer pool.

For more information, refer to the loading with external tables chapter in the IBM Informix: Administrator's Reference.