Latest MailTags very slow on Lion 10.7.3

stetner's Avatar

stetner

05 Feb, 2012 11:55 PM via web

Hi,

I have found that the new versions of Mail Tags make the Mail interface so slow it is unusable. I have had to disable MailTags.

Any idea as to why so slow or if there will be a fix?

Thanks,
Doug

  1. 2 Posted by stetner on 06 Feb, 2012 12:16 AM

    stetner's Avatar

    MailTags 3.0b1668

  2. Support Staff 3 Posted by Scott on 06 Feb, 2012 04:10 AM

    Scott's Avatar

    Hi Doug

    One thing to try -- in MailTags preferences turn off the option to "Show tags from related messages in message list"

    Scott

  3. 4 Posted by stetner on 07 Feb, 2012 01:50 PM

    stetner's Avatar

    That setting was already turned off.

    Doug

  4. Support Staff 5 Posted by Scott on 07 Feb, 2012 03:07 PM

    Scott's Avatar

    Hi Doug

    Can you try this build
    http://dl.dropbox.com/u/2113086/Prerelease/MT3/MailTags3.0b1678.dmg
    I specifically addressed what I think is the performance issue

    Scott

  5. 6 Posted by stetner on 08 Feb, 2012 10:34 AM

    stetner's Avatar

    Still is slow. When using the arrow keys to move from one message to another in a local mail folder I see delays of about 3 seconds before the text of the next email appears when MailTags is active, and it is virtually instantaneous when MailTags is not active.

    Doug

  6. 7 Posted by mavci on 08 Feb, 2012 12:41 PM

    mavci's Avatar

    I totally agree with stetner. Same problem here, and Mail.app is crashing every hour or so with MailTags 3.0 P3.

  7. Support Staff 8 Posted by Scott on 09 Feb, 2012 04:18 AM

    Scott's Avatar

    @stetner

    Is it just the display of the message in the preview panel?
    - Does the message have a large number of related/conversation messages associated with it - If you turn off the "show tag icon in Message Viewer" option, does it speed up?

  8. Support Staff 9 Posted by Scott on 09 Feb, 2012 04:18 AM

    Scott's Avatar

    @mavci

    the following build
    http://dl.dropbox.com/u/2113086/Prerelease/MT3/MailTags3.0b1678.dmg

    should rectify most of the stability issues

  9. 10 Posted by stetner on 09 Feb, 2012 06:17 AM

    stetner's Avatar

    The preview panel, I never open messages in their own window.

    No difference turning off "show tag icon in Message Viewer"

    No, in general most messages have one or two replies, or none at all.

    Doug

  10. Support Staff 11 Posted by petra on 09 Feb, 2012 04:08 PM

    petra's Avatar

    Thanks the additional information Doug.

    We're working hard to track this down.

    Petra

  11. Support Staff 12 Posted by petra on 17 Feb, 2012 05:49 PM

    petra's Avatar

    Hello Doug,

    Yesterday we released MailTags 3 preview 3.1 which resolved a number of memory problem resulting in crashes and leaks.

    We would appreciate if you could give this release a try and let us know if there is an improvement on your front

    http://www.indev.ca/MailTags.html,

    or directly via the following link:
    http://dl.dropbox.com/u/2113086/Prerelease/MT3/MailTags3.0b1696.dmg

    Petra

  12. 13 Posted by stetner on 18 Feb, 2012 11:12 PM

    stetner's Avatar

    Still seems very slow. It took about 20 minutes to filter 150 messages. The rules move the message to a folder, apply about 4 mailtags, and then 'stop evaluating rules'.

    Without the mailtaging it takes about a minute to do the same.

  13. Support Staff 14 Posted by Scott on 19 Feb, 2012 12:03 AM

    Scott's Avatar

    Hi Doug

    This seems like a different issue than what was initially reported. My understanding was that you were reporting performance problems when viewing messages. How does Preview 3.1 fare against that issue.

    As for performance wrt to rules, can you confirm that it is a different issue.

    Scott

  14. 15 Posted by stetner on 19 Feb, 2012 03:37 AM

    stetner's Avatar

    No, still slow going from message to message as well.

    Tested today moving from one message to another in a local mailbox takes about 8 seconds.

    Doug

  15. Support Staff 16 Posted by Scott on 19 Feb, 2012 03:57 AM

    Scott's Avatar

    can you open activity monitor , select Mail in the process list and then click sample. the quickly switch to Mail and move from one message to the other to effect the slowdown

    copy and paste the sample in your response

    thanks

  16. 17 Posted by stetner on 19 Feb, 2012 05:58 AM

    stetner's Avatar

    On 19/02/2012, at 1:56 PM, Scott wrote:

    >
    > // Add your reply above here
    > ==================================================
    > From: Scott
    > Subject: Latest MailTags very slow on Lion 10.7.3
    >
    > can you open activity monitor , select Mail in the process list and then click sample. the quickly switch to Mail and move from one message to the other to effect the slowdown
    >
    >
    > copy and paste the sample in your response
    >
    > thanks
    >
    > View this Discussion online: http://support.indev.ca/discussions/mailtags-3-preview-1/1261-latest-mailtags-very-slow-on-lion-1073
    > --
    >
    > To unsubscribe and stop receiving emails from http://support.indev.ca, visit
    > http://support.indev.ca/unsubscribe/7c9557b4be2d8e406a14e147a62242e305e1c2cc
    >
    >

  17. Support Staff 18 Posted by Scott on 19 Feb, 2012 12:45 PM

    Scott's Avatar

    thanks. this pinpoints where the problem is. i'll work on it today

    ***@Indev.ca
    Revolutionary enhancements for OS X Mail.app

    On 2012-02-19, at 12:58 AM, "stetner" <***@tenderapp.com> wrote:

    >
    > // Add your reply above here
    > ==================================================
    > From: stetner <***@stetner.org>
    > Subject: Latest MailTags very slow on Lion 10.7.3
    >
    >
    > On 19/02/2012, at 1:56 PM, Scott wrote:
    >
    >>

  18. Support Staff 19 Posted by Scott on 19 Feb, 2012 01:50 PM

    Scott's Avatar

    This build should fix the speed issue between messages

    http://dl.dropbox.com/u/2113086/Prerelease/MT3/MailTags3.0b1710.dmg

    However, it may still have slowdown when opening the tag window.

    The problem is when querying the MailTags database for all the keywords for listing them in the tags window

     +     !   :   |     +             !   : | +       !   :     | +   !         1769 -[EGODatabase executeQuery:]  (in MailTags) + 72  [0x10b822708]
        +     !   :   |     +             !   : | +       !   :     | +   !           1769 -[EGODatabase executeQuery:parameters:]  (in MailTags) + 76  [0x10b822f7c]
        +     !   :   |     +             !   : | +       !   :     | +   !             1769 -[EGODatabase executeQuery:parameters:cacheStatement:]  (in MailTags) + 1588  [0x10b822d44]
        +     !   :   |     +             !   : | +       !   :     | +   !               1769 sqlite3_step  (in libsqlite3.dylib) + 1883  [0x7fff826f0a5b]
        +     !   :   |     +             !   : | +       !   :     | +   !                 1570 sqlite3VdbeExec  (in libsqlite3.dylib) + 3181  [0x7fff826f231d]
        +     !   :   |     +             !   : | +       !   :     | +   !                 : 771 sqlite3BtreeInsert  (in libsqlite3.dylib) + 375  [0x7fff8271d3e7]
    

    The first # indicates amount of time spent in that specific function -- the real problem inidcates that it is taking a lot of time to cycle through the list of keywords you have to compose a list.

    This should be almost instant.

    So a few questions.

    How many keywords are in use in your system
    you can find out with the terminal command:

     sqlite3 ~/Library/Mail/Indev/MailTagsData.db "select count(distinct keyword) from keywords"
    

    do you have any keywords that seem to be abnormal in size or information
    you can get your full keyword list with the terminal command

    sqlite3 ~/Library/Mail/Indev/MailTagsData.db "select distinct keyword from keywords order by keyword collate nocase"
    

    Scott

  19. Scott closed this discussion on 19 Feb, 2012 01:50 PM.

  20. stetner re-opened this discussion on 19 Feb, 2012 10:49 PM

  21. 20 Posted by stetner on 19 Feb, 2012 10:49 PM

    stetner's Avatar

    That build did fix the message to message display speed. It is good now. The processing of rules still seems slow though, and I also notice if I delete say 80 messages it takes a while too, probably like a 'move to trash'.

    I have been focusing on my laptop, as that is where I noticed it most.

      
    For my laptop:
    
    Not a lot of tags at all.
    
    gollum  08:36:09 ~  
    stetner 576 $ sqlite3 ~/Library/Mail/Indev/MailTagsData.db "select count(distinct keyword) from keywords"  
    48
    
    gollum  08:36:49 ~  
    stetner 577 $ sqlite3 ~/Library/Mail/Indev/MailTagsData.db "select distinct keyword from keywords order by keyword collate nocase"  
    2009  
    2009_mailrule  
    2010  
    2010_mailrule  
    2011  
    2011_mailrule  
    AAssorted_mailrule  
    Admin_mailrule  
    Archive_mailrule  
    Assorted_mailrule  
    bootimages  
    butthead  
    closure  
    dns  
    Doug_mailrule  
    ***@hp.com_mailrule  
    ESX_mailrule  
    Forums_mailrule  
    holiday  
    ImapStuff_mailrule  
    Linux_mailrule  
    MacStuff_mailrule  
    MacUsers_mailrule
    
    NA_mailrule  
    NAmed  
    Networking  
    newpc
    
    OO_mailrule  
    OpenSource_mailrule  
    OpenVpn_mailrule  
    OPS_mailrule  
    osprovisioning  
    Patches_mailrule  
    Patching  
    sa78  
    SA__mailrule
    
    SA_mailrule
    
    SE_mailrule  
    ServerAutomation  
    SPARKS_mailrule  
    Support_mailrule  
    Training_mailrule  
    windows  
    xmas
    
    
    For my desktop:
    
    samwise  01:37:24 ~  
    stetner 558 $ sqlite3 ~/Library/Mail/Indev/MailTagsData.db "select count(distinct keyword) from keywords"  
    220
    
    samwise  01:37:34 ~  
    stetner 559 $ sqlite3 ~/Library/Mail/Indev/MailTagsData.db "select distinct keyword from keywords order by keyword collate nocase"  
    123rf_mailrule  
    2007_mailrule  
    2008_mailrule  
    2009_mailrule  
    2010-2011 tax  
    2010_mailrule  
    2011_mailrule  
    _Other_mailrule  
    Aaron_mailrule  
    Accept_mailrule  
    Accepted_mailrule  
    ACM_mailrule  
    Admin_mailrule  
    airconditioner  
    Alamy_mailrule  
    All73_mailrule
    
    Anne_mailrule  
    Apple_mailrule  
    Armstrong_mailrule  
    Assorted_mailrule  
    AusCERT_mailrule  
    Badmail_mailrule  
    BadSales_mailrule  
    bax_mailrule  
    BBEdit_mailrule  
    BigStock_mailrule  
    Blog_mailrule  
    Bob__Marlene_mailrule  
    brianmelB_mailrule  
    bryant_mailrule  
    Camry_mailrule  
    CBC_mailrule
    
    Closed_mailrule
    
    codewarrior_mailrule  
    CommBank_mailrule  
    Courses_mailrule  
    crypto_mailrule  
    CurrentProbs_mailrule  
    Daphne_mailrule
    
    DavidSteel_mailrule  
    Des_mailrule  
    dilbert_mailrule
    
    dive  
    dive_mailrule
    
    
    DonSjoberg_mailrule  
    Doug_mailrule  
    Dreamstime_mailrule  
    dyndnscron_mailrule  
    ebay_mailrule  
    EFA_mailrule  
    EFF_mailrule  
    Enver_mailrule  
    Estate_mailrule  
    Facebook_mailrule  
    Family_mailrule  
    Financial_mailrule
    
    Friends_mailrule  
    Fun_mailrule
    
    
    GraphicConverter_mailrule  
    gregN_mailrule  
    Guyonne_mailrule  
    Hilda_mailrule  
    homeoffice  
    hp
    
    
    iChat_mailrule  
    ikelite  
    indev  
    Ingrid_mailrule  
    ISP_mailrule  
    iStockPhoto_mailrule
    
    Jill_mailrule
    
    jobs_mailrule
    
    
    JoyStok_mailrule  
    JRNoble_mailrule  
    Kathleen_mailrule
    
    Kirbys_mailrule  
    LaTeX_mailrule  
    LaunchBar_mailrule  
    Lauren_mailrule
    
    Licenses_mailrule  
    limew_mailrule  
    limewire_mailrule  
    linux-mag_mailrule  
    Lists_mailrule  
    LouiseW_mailrule  
    Lui_mailrule  
    Mac  
    mailacton  
    mailtags  
    Marcus_mailrule  
    Marj_mailrule
    
    master_mailrule  
    Melinda_mailrule
    
    MikeColetteThompson_mailrule  
    MMM_mailrule  
    MMMG_mailrule
    
    mysql_mailrule  
    Nell  
    Nell_mailrule  
    Newt_mailrule  
    Newton_mailrule  
    Nortel_mailrule  
    Omni_mailrule  
    Other_mailrule  
    OtherMenu_mailrule
    
    
    Photo_mailrule  
    photography  
    Pre2007  
    printer\_hack\_mailrule  
    ProgSwitch_mailrule  
    RedBubble_mailrule  
    RegLic_mailrule  
    Reject_mailrule  
    Rejected_mailrule  
    relatives_mailrule  
    Research_mailrule
    
    
    Ross_mailrule  
    S4057902_mailrule  
    Safety_mailrule  
    Save_mailrule  
    save_mailrule  
    SavedProgDocs_mailrule  
    Security_mailrule
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    Shutterstock_mailrule  
    Sjoberg_mailrule  
    software  
    Software_mailrule  
    SpamSieve_mailrule  
    Status_mailrule  
    stetner.org_mailrule  
    Steve_mailrule  
    Stockxpert_mailrule  
    subscription  
    Subversion_mailrule  
    Suncorp_mailrule  
    taxes  
    Telstra_mailrule  
    Test_mailrule  
    TestMail_mailrule  
    TeX_mailrule  
    ThisIsTrue_mailrule
    
    tohome_mailrule  
    Tony_mailrule  
    underwater  
    UofQ_mailrule  
    UQSent_mailrule  
    voodoo_mailrule  
    vox_mailrule  
    VPC_mailrule  
    WestNet_mailrule  
    Work_mailrule  
    Xmas99_mailrule  
    xplane_mailrule  
    zaqzaq  
    ZSent_mailrule
    
    
  22. Support Staff 21 Posted by Scott on 19 Feb, 2012 10:56 PM

    Scott's Avatar

    Hi Doug

    Nothing looks crazy here

    it may be that the database need rebuilding

    First try this in terminal

    sqlite3 ~/Library/Mail/Indev/MailTagsData.db "vacuum"
    

    If this doesn't do anything then just rebuild the tag database from MailTags preferences.

    Scott

  23. 22 Posted by stetner on 22 Feb, 2012 10:37 AM

    stetner's Avatar

    Hi Scott,

    vacumed the database, but I am still seeing slow rule filtering, this morning it took

    13 minutes to filter 169 messages.

    I also found the system hanging occasionally with a 'Updating Mailtags database' message in the activity window.

    I grabbed a sample when that was happening here:

    Doug

  24. 23 Posted by stetner on 22 Feb, 2012 10:40 AM

    stetner's Avatar

    Also, it takes about 12 seconds to expand the tag window from the '+' mark on the blue tag thing on the right.

    On 22/02/2012, at 8:37 PM, Mr. Stetner Doug wrote:

    > Hi Scott,
    >
    > vacumed the database, but I am still seeing slow rule filtering, this morning it took
    >
    > 13 minutes to filter 169 messages.
    >
    > I also found the system hanging occasionally with a 'Updating Mailtags database' message in the activity window.
    >
    > I grabbed a sample when that was happening here:
    > <UpdatingMailTagDatabase.txt>
    >
    > Doug
    >
    > On 20/02/2012, at 8:56 AM, Scott wrote:
    >
    >>

  25. Support Staff 24 Posted by Scott on 22 Feb, 2012 12:07 PM

    Scott's Avatar

    I think the thing to do is to rebuild the tag database. In Preferences on the Messages tab you can click rebuild Mailtags For options select rebuild tag library and to read tags from headers

    Scott

    ***@Indev.ca
    Revolutionary enhancements for OS X Mail.app

  26. 25 Posted by stetner on 23 Feb, 2012 01:33 AM

    stetner's Avatar

    I rebuild tag library and to read tags from headers and it still took 15 minutes to filter about 130 messages this morning and it is still taking 8+ seconds to expand the tag thing on the rigt with the '+' button.

    Doug

  27. Support Staff 26 Posted by Scott on 23 Feb, 2012 01:40 AM

    Scott's Avatar

    thanks for the update

    Something occurred to me today and I think I know what could be wrong -- I didn't have the items in the database indexed for faster searches so I remedied this

    Here is another build
    http://dl.dropbox.com/u/2113086/Prerelease/MT3/MailTags3.0b1727.dmg

  28. 27 Posted by stetner on 23 Feb, 2012 03:10 AM

    stetner's Avatar

    Seems to be much better, only a second or two to open the '+' window, and filtering about 20 messages went quickly. I will have a go again tomorrow morning when I process my overnight mail which is usually 1-200 messages.

    Thanks,
    Doug

  29. 28 Posted by stetner on 23 Feb, 2012 10:48 PM

    stetner's Avatar

    Looks goos Scott, 1.5 minutes to filter 140 messages, '+' key comes up in about a second, and the moving from message to message is fast.

    Looks like you can close this one out.

    Thanks,
    Doug

  30. Scott closed this discussion on 23 Feb, 2012 10:59 PM.

Comments are currently closed for this discussion. You can start a new one.