Handling Large Objects

When you decide on the specific data type to represent a DataBlade module object—or its elements—keep in mind that the maximum row size for a database table is 32 KB. (Row size is the sum of the sizes of the columns in that row.)

Your Informix database server provides the LVARCHAR data type, which can hold up to 32,790 KB of text data. Larger objects and binary objects are called smart large objects, and your Informix database server provides facilities for high-performance access to smart large objects.

A smart large object is an object that is logically stored in a table column of type BLOB (binary large object, for binary data) or CLOB (character large object, for text data) but is physically stored in an sbspace.

An sbspace is a logical storage area that contains one or more chunks that store only BLOB and CLOB data. Sbspaces must be created before you can create any smart large objects; after sbspaces are created, they are managed by your Informix database server.

Smart large objects are "smart" because they provide the following features:

• They provide random access to their data, using an operating-system-style interface (seek, read, write, and so on).
• They are recoverable in the event of a system crash (if the sbspace was created with logging enabled), and they obey transaction isolation modes.
• They have no maximum size.
• You can create and store indexes in them.
• You can access and manipulate them using SQL, ESQL/C, or the DataBlade API.

Within SQL, the only comparison operator you can use for data of types BLOB and CLOB is Equal() (=); however, you can perform additional operations using IBM Informix ESQL/C or the DataBlade API from your client application.

You can also use the IBM Informix Large Object Locator DataBlade module to handle large objects. This DataBlade module enables you to store large object data on the client computer. The IBM Informix Large Object Locator DataBlade module is included with your Informix database server. You must register the module's routines and data types in each database in which you plan to use the module.

When you design data types, ask yourself the following questions:

• Is the object represented by 32,790 KB or less of text data? If so, use the built-in LVARCHAR data type.
• Is the object represented by more than 32,790 KB of text data, or by binary data? If so, use the smart large object facilities provided by your Informix database server.
• Does it make sense to store the large object on the client computer? If so, use the IBM Informix Large Object Locator DataBlade module.

The following table lists large object topics and where you can find more information on them.

Most of these manuals are accessible through the InfoShelf.