Home | Previous Page | Next Page   Disk, Memory, and Process Management > Data Storage > Temporary Sbspaces >

Temporary Smart Large Objects

Use temporary smart large objects to store text or image data (CLOB or BLOB) that do not require restoring from a backup or log replay in fast recovery. Temporary smart large objects last for the user session and are much faster to update than smart large objects.

You create a temporary smart large object in the same way as a permanent smart large object, except you set the LO_CREATE_TEMP flag in the ifx_lo_specset_flags or mi_lo_specset_flags function. Use mi_lo_copy or ifx_lo_copy to create a permanent smart large object from a temporary smart large object. For details on creating temporary smart large objects, see the IBM Informix DataBlade API Programmer's Guide.

Important:
Store pointers to temporary large objects in temporary tables only. If you store them in standard tables and reboot the database server, it results in an error that says that the large object does not exist.

Table 30 compares standard and temporary smart large objects.

Table 30. Temporary and Standard Smart Large Objects
Characteristics Smart Large Object Temporary Smart Large Object
Creation flags LO_CREATE_LOG or LO_CREATE_NOLOG LO_CREATE_TEMP
Rollback Yes No
Logging Yes, if turned on No
Duration Permanent (until user deletes it) Deleted at end of user session or transaction
Table type stored in Permanent or temporary table Temporary tables
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]