Overriding Segment Length

From InterBase
Jump to: navigation, search

Go Up to How are Blob Data Stored?


You can override the segment length setting by including the ­MAXIMUM_SEGMENT option in a DECLARE CURSOR statement. For example, the following Blob INSERT cursor declaration overrides the segment length that was defined for the field, Blob2, increasing it to 1024:

EXEC SQL
DECLARE BCINS CURSOR FOR INSERT Blob Blob2 INTO TABLE 2
MAXIMUM_SEGMENT 1024;
Note: By overriding the segment length setting, you affect only the segment size for the cursor, not for the column, or for other cursors. Other cursors using the same Blob column maintain the original segment size that was defined in the column definition, or can specify their own overrides.

The segment length setting does not affect InterBase system performance. Choose the segment length most convenient for the specific application. The largest possible segment length is 65,535 bytes (64K).

Advance To: