Board index » delphi » DB only expands

DB only expands

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 !

 

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

Other Threads