home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.databases
- Path: sparky!uunet!elroy.jpl.nasa.gov!jato!mona!khioe
- From: khioe@mona.jpl.nasa.gov (Kent Hioe)
- Subject: Re: How to trim down dBASE IV database file ?
- Message-ID: <1992Aug20.170134.582@jato.jpl.nasa.gov>
- Keywords: dbase IV file
- Sender: nobody@jato.jpl.nasa.gov
- Nntp-Posting-Host: mona.jpl.nasa.gov
- Organization: jpl
- References: <1992Aug19.212534.11942@jato.jpl.nasa.gov> <1992Aug20.034649.16721@cam.compserv.utas.edu.au>
- Date: Thu, 20 Aug 1992 17:01:34 GMT
- Lines: 33
-
- In article <1992Aug20.034649.16721@cam.compserv.utas.edu.au> rhidding@esk.compserv.utas.edu.au (Robert Andrew Hidding) writes:
- >Try using the DBase command "PACK". Deleting a record only results in the
- >record being marked as deleted, but it isn't physically deleted until
- >"PACK"ed.
-
- I have tried that but the file size still remains the same.
-
- This is what I did:
-
- before record deletion :
- slhist.dbf 2546900 byte.
- # of records: 10500 records
-
- --------------------------------
- delete 10000 records
- pack
-
- --------------------------------
- After deletion:
- slhist.dbf 2546900 byte. <<< how come the size is the same as before ?
- # of records: 500 records.
-
-
- My original question was how to gain back the memory disk space ?
-
-
- Thank you for your help.
-
-
- --
- Kent
- khioe@juno.jp.nasa.gov
-
-