Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

database compaction

Status
Not open for further replies.

kitjamchinkee

Technical User
Aug 2, 2000
2
US
. are there any disadvantages in database compaction ? especially if it is in a multi-user environment? When can you compact your database?pls. help!!! thanks!!!
 
the only time you can compact a database is when you are the only person in the database.<br>as far as i know, there are no disadvantages to compacting.&nbsp;&nbsp;it's not something that necessarily has to be done every day, or even every week (unless you get a lot of db traffic).&nbsp;&nbsp;but it should be done periodically to save space. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top