The metadata pages in an sbspace contain information about the location of the smart large objects in the sbspace. Typically, these pages are read intensive. You can distribute I/O to these pages in one of the following ways:
For more information about the implications of mirroring, see Consider Mirroring for Critical Data Components.
Because the metadata pages are the most read-intensive part of an sbspace, place the metadata pages toward the middle of the disk to minimize disk seek time. To position metadata pages, use the -Mo option when you create the sbspace or add a chunk with the onspaces utility.
To spread metadata pages across disks, create multiple chunks in an sbspace, with each chunk residing on a separate disk. When you add a chunk to the sbspace with the onspaces utility, specify the -Ms option to allocate pages for the metadata information.
Although the database server attempts to keep the metadata information with its corresponding data in the same chunk, it cannot guarantee that they will be together.
When a smart large object spans multiple extents, the metadata area contains a separate descriptor for each extent. To decrease the number of descriptor entries that must be read for each smart large object, specify the expected final size of the smart large object when you create the smart large object.
The database server allocates the smart large object as a single extent (if it has contiguous storage in the chunk) when you specify the final size in either of the following functions:
For more information on the functions to open a smart large object and to set the estimated number of bytes, see the IBM Informix: ESQL/C Programmer's Manual and IBM Informix: DataBlade API Programmer's Guide.
For more information about sizing extents, see Sbspace Extent Sizes.