Re:DB only expands
Quote
"Eriksw" <erikenpa...@hetnet.nl> wrote in message
news:3d7edc1e$1@newsgroups.borland.com...
Quote
> Hi there,
> I'am using D6 and Interbase in combination with BDE.
> The problem i'am encountering is that the DB only grows. That
means that
> although if have deleted >50% of the contentof the DB, the size
of it isn't
> one byte smaller then before. Is there an option i forgot or
must u clean up
> the DB manualy ?
> What i'am i doing wrong !
You aren't doing anything wrong. IB will delete the records but it
doesn't reorganize the DB. It reuses the space as needed so it's
faster than asking for more space from the disk system. Backing up
and restoring the DB is the only way to actually reclaim space.
--
Woody (TMW)
----------------------
"To invent, you need a good imagination and a pile of junk."
Thomas Edison