How do I shrink the size of my database?

Troy Wolbrink — Mon, 29 Sep 2008 17:36:59 GMT

Current revision posted to Frequently Asked Questions by Troy Wolbrink on 9/29/2008 5:36:59 PM

How do I shrink the size of my database?

Filed under: Managing Database Files

As you use TntMPD you might notice that the file can start to grow large.

One of the things that you can do to reduce the amount of hard drive space that your database file is using is to "compact" your file. Under the "File", click on "Compact and Repair Database". Keep in mind that this is done automatically for you every 30 days as you use TntMPD.

Another thing you can do is check the size of the pictures you may have imported in TntMPD. Under the "Tools" menu, click on "All Pictures". This gives you a way to quickly scan all of your pictures and see how much space each picture takes up. A good rule of thumb is that a picture shouldn't take up more than 50 to 60 KB max. If it takes up more than this consider deleting it and adding a smaller picture. I find that JPEG is the best format for pictures of this type and that most of my pictures are only 25 KB.

If you want to backup your database or move it to another computer you should consider compressing the file first. I personally like to use WinZip for this. (NOTE: Windows XP comes with a file compression tool built-in.) This can typically cut the file size in half or more, which can be very helpful if you are short on backup space, or if you are going to email the file over a slow modem.

How do I shrink the size of my database?

Troy Wolbrink — Mon, 29 Sep 2008 17:36:59 GMT

Revision 1 posted to Frequently Asked Questions by Troy Wolbrink on 9/29/2008 5:36:59 PM

As you use TntMPD you might notice that the file can start to grow large.