Re: Sizing of char,varchar and text fields

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? -- Martin Andrews andrewm@ccfadm.eeg.ccf.org Section of Neurological Computing Phone (216)444-7485 Cleveland Clinic Foundation Fax (216)445-6617