Reduce the size of your database

• 
  Michael Lazar
• Published: 07 Oct 2003

View member feedback to this tip.

Here are a few tips that I've found useful in keeping the Database Monster under control.

1. Schedule a weekly compact program document. The standard switch is "-S10", which tells the compacter to run against any database with more than 10% white space. This performs a copy style compact.

2. Archive documents. Whether it is a mail file or some other database, archiving old (but still needed) documents to another server will keep your production database small (once they are compacted). Remember, large databases are often slower and more prone to corruption than small databases. Keeping databases small has added benefits other than just freeing up disk space.

3. Educate your users on how to properly store and respond to mail. (This is for mail databases.) Nothing kills space faster than someone who sends a message to a bunch of people with an attachment, and then someone replies to all with history and resends the attachment. The cycle continues, and the next thing you know someone has six copies of the same attachment. I can't stand it when this happens. Thankfully, this is addressed in ND6 with the new "Reply w/out attachments" feature. However, this leads back to educating your users. They need to know how to be good corporate citizens.

4. Keep views to a minimum. (This one is most likely for non-mail files.) The more views you have, the more space you will use. This is because the view indexes have to be built and maintained by the server. In large databases with many views, the indexes can often take up more space than the actual documents!

MEMBER FEEDBACK TO THIS TIP

Regarding keeping a small mail file, here is what I tell my users: Follow these three practices to keep your mail file small without having to deal with archiving.

• Periodically remove the largest 50 messages or attachments.
• Zip files before attaching when appropriate. (We use the Zipmail product to simplify this.)
• Use a Notes database rather than e-mail for sharing attachments to groups of people. (A central document library or discussion DB customized to allow assigning readers and editors to each document works great.)

1. Open the All Documents view.
2. Click on the column header to sort by size.
3. Remove the attachments from the largest 50 messages (first two screens) or delete the messages entirely.
4. Repeat monthly.

-- David H.

Do you have comments of your own? Let us know.