The new sp_iqsetcompression stored procedure controls the compression of columns of data type LONG BINARY and LONG VARCHAR when writing database buffers to disk and allows you to disable compression. This functionality saves CPU cycles, because certain data formats stored in a LONG BINARY or LONG VARCHAR column (for example, JPG files) are already compressed and gain nothing from additional compression. The new sp_iqshowcompression stored procedure displays the compression setting of large object columns.
For more information on these stored procedures, see “sp_iqsetcompression procedure” and “sp_iqshowcompression procedure” in Chapter 5, “Stored Procedure Support” of Large Objects Management in Sybase IQ.
