Subject | can you "compact" a database ? |
---|---|
Author | peter_nn0 |
Post date | 2007-12-28T22:15:31Z |
Hi,
merry Christmas!
I wonder if it's possible to "compact" a database, in other words to
delete permanently the deleted data.
I have a database ~50MB. After deleting all the entries in most tables,
the database file size is practically the same, while it should be 2MB
at most. This means data is just marked as deleted, but in fact
remains - I'm looking for a way to remove it really.
Thanks.
merry Christmas!
I wonder if it's possible to "compact" a database, in other words to
delete permanently the deleted data.
I have a database ~50MB. After deleting all the entries in most tables,
the database file size is practically the same, while it should be 2MB
at most. This means data is just marked as deleted, but in fact
remains - I'm looking for a way to remove it really.
Thanks.