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]