Re: Sizing of char,varchar and text fields

In article <1995Aug22.130725.5185@bme.ri.ccf.org>, <andrewm@ccfadm.eeg.ccf.org> writes: > Alexander J. Oss (alex.oss@films.com) wrote: > > : I believe that is not just a rumor about taking up at > : least one block for each BLOB entry (and our block size > : is also 2k). > > : You could try keeping the files outside of the database, > : and store only the filenames inside... > > I thought that was only true if the blobs were in a separate > blob-space. If they are in the same space as the table I thought > there was no (or different) minimum allocation size. Anyone no > more? Whoops, looks like you're right <sheepish g>. P. 2-130 of the Online 5.0 manual: "Blobs can share dbspace blob pages if more than one blob can fit on a single page, or if more than one trailing portion of a blob can fit on a single page." ..but hmmm! p. 10-17 of the SQL Tutorial: "Each blob data item occupies a whole number of pages." Using their space-estimating scheme example, it looks like each entry uses a whole page. Also, p. 9-19: "It [a blob] is allocated in whole disk pages; a short item wastes space." Well, now I'm confused! Any clarification from out there?