Re: Very slow database start after a big file deletion

Tobias Downer <[email protected]> Thu, 17 Feb 2005 17:47:34 -0800
Newsgroups gmane.comp.db.mckoi
Message-ID <[email protected]>
Hi,

You should try using the COMPACT TABLE command on the table where the 
data was deleted from.  This may improve startup performance.

Toby.


Grégoire Dubois wrote:

> Hi all,
> 
> When I delete a lot of data (big files of hundreds of Mb), the restart
> of the database is very slow. And after that, each time I start the
> database, it's very slow. A lot slower than before the deletion.
> 
> Any solution?
> 
> Thank you very much.
> Greg.



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]