A faster way to speed up Mail.app

Discussion in 'MacBytes.com News Discussion' started by MacBytes, Mar 1, 2007.

  1. MacBytes
    Expand Collapse
    macrumors bot

    Joined:
    Jul 5, 2003
    #1

    [​IMG]

    Category: Tips and How To's
    Link: A faster way to speed up Mail.app
    Description:: As everyone knows, it is possible to get quite a speed boost out of Mail.app by stripping all the bloat out of its Envelope index, an SQLite database Mail uses to store senders, recipients, subjects and so on. In the past, I suggested that quitting Mail, deleting the Envelope file and restarting Mail would force a rebuild that produces a leaner, faster email experience. In October last year Dallas noticed a faster way to get the same result using three Terminal commands.

    Posted on MacBytes.com
    Approved by Mudbug
     
  2. Mudbug
    Expand Collapse
    Administrator emeritus

    Mudbug

    Joined:
    Jun 28, 2002
    Location:
    North Central Colorado
    #2
    I just did this myself, and to say there's a speed difference may be the understatement of the decade. Mail.app is easily twice the speed it was before running this.
     
  3. MacBoobsPro
    Expand Collapse
    macrumors 603

    MacBoobsPro

    Joined:
    Jan 10, 2006
    #3
    What is it deleting exactly?

    What are the consequences?
     
  4. mkrishnan
    Expand Collapse
    Moderator emeritus

    mkrishnan

    Joined:
    Jan 9, 2004
    Location:
    Grand Rapids, MI, USA
    #4
    This doesn't interrupt threading of subjects or anything, does it? I have to try this when I get home!
     
  5. MacBoobsPro
    Expand Collapse
    macrumors 603

    MacBoobsPro

    Joined:
    Jan 10, 2006
    #5
    My plan exactly but I need to know what it is actually doing incase something goes wrong.
     
  6. dr_lha
    Expand Collapse
    macrumors 68000

    Joined:
    Oct 8, 2003
    #6
    Its not deleting anything, its optimizing the database

    Faster Mail.app
     
  7. redwin11
    Expand Collapse
    macrumors member

    Joined:
    Feb 12, 2006
    Location:
    UK
    #7
    Impressive!
    The sluggishness has disappeared, and even opening 5-10Mb attachments is quite nippy.
     
  8. MacBoobsPro
    Expand Collapse
    macrumors 603

    MacBoobsPro

    Joined:
    Jan 10, 2006
    #8
    Freakin Nora. It works great. Much faster!

    Sweet! :D
     
  9. Jonnyfive
    Expand Collapse
    macrumors regular

    Joined:
    Feb 28, 2007
    Location:
    British Columbia
    #9
    I got an error in terminal when trying to enter the last line... am I doing something wrong?

    sqlite> sqlite> vacuum subjects;
    SQL error: near "sqlite": syntax error
     
  10. redwin11
    Expand Collapse
    macrumors member

    Joined:
    Feb 12, 2006
    Location:
    UK
    #10
    Yes
     
  11. Jonnyfive
    Expand Collapse
    macrumors regular

    Joined:
    Feb 28, 2007
    Location:
    British Columbia
    #11
    Well what am I doing wrong?
     
  12. wrldwzrd89
    Expand Collapse
    macrumors G4

    wrldwzrd89

    Joined:
    Jun 6, 2003
    Location:
    Solon, OH
    #12
    Hmm... I'll have to try this once I return to my Mac. My Mail.app hasn't been particularly sluggish.
     
  13. iMeowbot
    Expand Collapse
    macrumors G3

    iMeowbot

    Joined:
    Aug 30, 2003
    #13
    You don't want to type the sqlite> part, that's the command prompt for the program.
     
  14. redwin11
    Expand Collapse
    macrumors member

    Joined:
    Feb 12, 2006
    Location:
    UK
    #14
    Copy and paste it, ensures there's no errors for a start.
     
  15. Jonnyfive
    Expand Collapse
    macrumors regular

    Joined:
    Feb 28, 2007
    Location:
    British Columbia
    #15
    Well, I guess that means copy and paste wouldn't work... Smart Guy.
     
  16. wrldwzrd89
    Expand Collapse
    macrumors G4

    wrldwzrd89

    Joined:
    Jun 6, 2003
    Location:
    Solon, OH
    #16
    It does work, you just have to make sure you don't accidentally copy the prompt. Also, don't try to copy both lines at once, as it won't work.
     
  17. Jonnyfive
    Expand Collapse
    macrumors regular

    Joined:
    Feb 28, 2007
    Location:
    British Columbia
    #17
    Yeah I got it to work. Just saying that copying and pasting everything written on the page isn't the solution.
     
  18. redwin11
    Expand Collapse
    macrumors member

    Joined:
    Feb 12, 2006
    Location:
    UK
    #18
    You're the one who's struggling with three lines of text!
     
  19. Jonnyfive
    Expand Collapse
    macrumors regular

    Joined:
    Feb 28, 2007
    Location:
    British Columbia
    #19
    Touche.
     
  20. MacBoobsPro
    Expand Collapse
    macrumors 603

    MacBoobsPro

    Joined:
    Jan 10, 2006
    #20
    I copied and pasted all 3 lines and it seems to have worked for me? :confused:

    So for people who are struggling can someone post a step by step? We are here to help people right? Maybe I didnt do it right but it seems faster to me.
     
  21. mainstreetmark
    Expand Collapse
    macrumors 68020

    mainstreetmark

    Joined:
    May 7, 2003
    Location:
    Saint Augustine, FL
    #21
    Really?!?

    Step 1: Quit mail
    Step 2: Open Terminal (use Spotlight to find 'Terminal')
    Step 3: Copy this bit and paste it in the terminal directly:
    ... and press return.
    Step 4: When it says "sqlite>" again, close Terminal
    Step 5: Open Mail

    If you still have trouble, it's time to reconsider your ability to own a computer.

    Mine sped up significantly!
     
  22. devilot
    Expand Collapse
    Moderator emeritus

    devilot

    Joined:
    May 1, 2005
    #22
    Thanks, it's appreciated, I'm sure by others too timid to now reply. :rolleyes:

    Anyway, definitely speeds things up. Can't wait to get home and try this out on my iMac. That fool needs the speed up more than my MB. :eek:
     
  23. mainstreetmark
    Expand Collapse
    macrumors 68020

    mainstreetmark

    Joined:
    May 7, 2003
    Location:
    Saint Augustine, FL
    #23
    I'll do you all one better. Here's a quick app to do it for you:

    A buddy of mine pointed out that you can use iCal, set a monthly alarm, and for the alarm action, use 'Run Script' and point to this file, and set it to go off every month. Neat, eh?
     

    Attached Files:

  24. IJ Reilly
    Expand Collapse
    macrumors P6

    IJ Reilly

    Joined:
    Jul 16, 2002
    Location:
    Palookaville
    #24
    I just tried the easy way, deleting the Envelope file. After about five minutes of rebuilding, it had been reduced from 10 Mb to about 8 Mb. Speed improvements? Negligible, at best. Maybe mine wasn't large enough to make much difference, but I am unimpressed.
     
  25. mainstreetmark
    Expand Collapse
    macrumors 68020

    mainstreetmark

    Joined:
    May 7, 2003
    Location:
    Saint Augustine, FL
    #25
    Mine went from 11 to 5. It used to be I could see the inbox populating up with messages. Would take seconds sometimes. Now, when Mail stars, my inbox just appears with no delay.
     

Share This Page