matsu

VACUUMing your mail.app with SQLite

Via BoingBoing and Cory Doctorow (who switched to Ubuntu from Mac OS X), a speedup tip for mail.app – pretty easy and fast.

1. Close mail.app
2. Backup your mail
3. Open a terminal window
4. Go to your mail directory with cd ~/Library/Mail
5. Start SQLite (which is installed by default) with sqlite3 Envelope\ Index
6. Clean up your mail DB with vacuum subjects;
7. Wait for the sqlite prompt to reappear
8. Exit SQLite with ctrl-D
9. Open mail.app again and enjoy the improved speed!