Re: Question on BLOB stored in the table

Manickam R Muthukumar wrote: > > Hello cdi folks, > > When we specify a BLOB column to be stored > in the table, it stores the 56-byte description > with the row and stores the BLOB data somewhere in > that Tblspace. According to Infx documentation a > BLOB column occupies at least on page. My > understanding is that when ever row is inserted > with not null BLOB column, it uses one disk page > for the BLOB column apart from storing other > columns. Is it correct ?? If not how does it work M, this is not correct. A BLOB may be in the TBLSPACE or in a separate BLOB space. When it is in the BLOBspace, it will be allocated a full BLOB page even if the actual data is only 1 byte of BLOB data. If the BLOB is in the TBLspace, then the data will be stored on a BLOB page in the TBLspace but if it does not fill this BLOB page, the space is still available to be used by blob data of other rows. If there is no BLOB data in the INSERT, then no disk space is allocated for the BLOB. Of course, the 56-byte blob descriptor is still part of the row, pointing to nada. > -- > ~~~~ SMILE !! increases the face value Now that's a nice tag line! None of the cynicism so popular in the OnLine community! > !! Strong believer in making things work !! > (Opinion expressed here are mine only) I know what you mean. Making things work is not always a high priority! -- -- Jake (Has high hopes for cynicism) . . _..-'( )`-.._ ./'. '||\\\\. }\\_/{ .//||` .`\\. ./'.|'.'||||\\\\|.. )o o( ..|//||||`.`|.`\\. ./'..|'.|| |||||\\`````` \\'@'/ ''''''/||||| ||.`|..`\\. ./'.||'.|||| ||||||||||||. | .|||||||||||| ||||.`||.`\\. /'|||'.|||||| ||||||||||||{ | }|||||||||||| ||||||.`|||`\\ '.|||'.||||||| ||||||||||||{ | }|||||||||||| |||||||.`|||.` '.||| ||||||||| |/' ``\\||`` | ''||/'' `\\| ||||||||| |||.` |/' \\./' `\\./ \\!|\\ /|!/ \\./' `\\./ `\\| V V V }' `\\ /' `{ V V V \\ \\ \\ V / / / +-----------------------------------------------------------+ | Impeccable Logic: A thought process which successfully | | resists chicken bites | +-----------------------------------------------------------+