Speed up Mail.app

[Robert La Ferla]

I wouldn't do that if I were you.  The sqlite in Tiger is an old  
version (3.1.3) that has bugs w/auto-vacuum.  Specifically, there are  
two autovacuum bugs that can corrupt your database. I upgraded my  
sqlite (fairly risky in itself) to the latest version so I could do  
it but I would not advise people to do it.

Robert La Ferla
OS X / Cocoa Consultant

On Mar 4, 2007, at 7:36 PM, LuKreme wrote:

> On 4-Mar-2007, at 09:43, Robert La Ferla wrote:
>> Thank you!!!  That fixed my problem even though the index after  
>> vacuuming is the same (very large) size.  I don't know if they are  
>> planning to or not but Apple should turn on auto-vacuum for Leopard.
>
> You can do it yourself.
>
>
>   cd ~/Library/Mail
>   mv Envelope\ Index Backup
>   sqlite3 Envelope\ Index "PRAGMA auto_vacuum=1;"
>   sqlite3 Backup ".dump" | sqlite3 Envelope\ Index
>   rm Backup
>
> there you go.
>
>
> -- 
> There is a tragic flaw in our precious Constitution, and I don’t  
> know what can be done to fix it. This is it: Only nut cases want to  
> be president.
>
>
>
> _______________________________________________
> MacOSX-talk mailing list
> MacOSX-talk at omnigroup.com
> http://www.omnigroup.com/mailman/listinfo/macosx-talk