Re: Very slow database start after a big file deletion

Grégoire Dubois <[email protected]> Fri, 18 Feb 2005 03:34:05 +0100
Newsgroups gmane.comp.db.mckoi
Message-ID <1108694045.6440.0.camel@Greg>
Thank you so much ! I'll go for it !

Le jeudi 17 février 2005 à 17:47 -0800, Tobias Downer a écrit :
> 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]
> 
> 



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