Re: Archive sizes

Neil Truby wrote: > > >> When you delete data froma table, the pages used by that table are not > free by the engine. << > > Yes, this seems to be the general concensus, and is born out by my > subsequent testing. I feel that this is an area where OnLine compares > unfavourably with other DBMSs. In Adabas, for example, only non-empty > pages will be written to an archive. Therefore, it makes no difference > whether a table has 100 pages or 1,000,000 - the archive size is > dependent upon the amount used. This seems much more sensible - what's > the point of archiving empty pages? As far as I know this changed in about version 6.x. Only pages contining useful stuff are copied to the tape. But I could be wrong. ;-) Cheers, -- Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+