I didn't know that every time we delete a record, this space can be use for
other records. Now, if we delete the records, the speed of the database will
grow up as initially? I think yes as the index tables will be empty. A?



Regards

Dennis





_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Stefan Heymann
Sent: Wednesday, September 27, 2006 1:33 PM
To: Dennis
Subject: Re: [firebird-support] how to reduce the file size of the database
after large amount of deletes ref/eDN8072730811

> I found a way backing up and restoring the database. Any other
> suggestion?

A Backup & Restore is the *only* way to reduce the file size of a
Firebird database.

BUT: When you delete records, their space becomes available for new
records. So Dimitry is right: what's the point? One month later the
database will have the old size again. And hard disk space is
extremely cheap these days.

Best Regards

Stefan

--
Stefan Heymann
www.destructor.de/firebird





[Non-text portions of this message have been removed]