Leland Scott has taken the best bits of several scripts that automate the vacuuming of Mail’s Envelope index and rolled them together into a solution that will automate the cleaning process using Mac Os X’s Launchd service.
The result, VacummMail, is a clever little utility that can be run anytime with two clicks of the mouse for a manual clean up.
It features a series of dialogs that tell you what is about to happen and what has happened, which is always satisfying:
Even better, the process can be automated by placing the app into your /Applications/Utilities folder and the included plist file into your ~/Library/LaunchAgents folder.
By default, this will run the app at 1 pm every Tuesday. If that time doesn’t suit, it can easily be changed using Lingon 
, an open source launchd configuration file editor:
You can get VacuumMail from Leland’s web site .
Why not just turn on auto vacuuming?
It’s not as efficient.
I seriously doubt you’ve measured whether the increase in time from having auto vacuuming on is greater than the impact of having the database get less and less efficient with every operation PLUS the cost of running maintenance on it. If you have, I’d like you see the results.
how do i download the link is down
i have been trying to runs some optimize scripts and get sql error:constraint failed