Re: Archive sizes

In article <32ECFDCD.485A@netcomuk.co.uk>, Neil Truby <ntruby@netcomuk.co.uk> writes >What algorithim does OnLine use when creating archives? I have deleted >a large amount of data from a main table in my application, then >onubload/onloaded the database. I had expected to see the size of the >archive drop substantially, perhaps from 1200MB to 800MB, but in fact >the archive is not very much smaller. I expect that the table now has a >large amount of unused pages allocated, but surely OnLine wouldn't dump >these, would it? Would it?! > >Neil Truby >Chase Bank >Bournemouth, UK Archivves worka at the page level thus there only needs to be one row on the page for the page to be archived. Also remember onunload/unload work at the page level as so only reduce the number of pages used in the table if the page has no rows on it. E.g. 1000 rows each on it's own page and you would see no different. Try using sql load/unload statements (Remember to turn logging off first!). -- David Williams