Re: free space in .dat files

In article <3s2m06$4c3@rcogate.rco.qc.ca> cat@tecsys.com "Catalin Badea" writes: > Charles Francis (ancrcs4!cfrancis@ancrcs4.attmail.com) wrote: > > : Using (rowsize + 4) * nrows may not come close to estimating the > : size of an Informix SE data file. > > : Unless the columns of the rows have been defined as not allowing > : NULLs every row stored may be a different length. <big snip> > The space required to store each row in the .dat file is the rowsize + 1. > (At least from C-ISAM version 2.0 to Standard Engine 7.1). I think we need a little help form Informix here! My understanding is that C-ISAM files are FIXED FORMAT e.g. all rows are stored as the same length. I may be getting confused with the Indexes where the 4 bytes are the 'hidden' index on the rowid. Certainly there must be an 'extra' per row as there is a deletion flag somewhere in all this. Jonathan Leffler to the rescue? Does he have an ACCURATE algorithm for the '.dat' files at least? Does one, indeed, exist?! :-) -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================