macosxhints.com: Speed up iPhoto ’09 by vacuuming its databases: “Speed up iPhoto ’09 by vacuuming its databases
Mon, Mar 2 2009 at 7:30AM PST
Submitted by wjv
My iPhoto ’08 used to start in seconds despite the 30,000+ photos I kept in it. But after I installed iLife ’09 and upgraded my iPhoto library, iPhoto ’09 would hang for several minutes with the dreaded beach ball on startup. Even worse, though was that opening any event would trigger another hang of a minute or more, as would viewing a photo full-screen. (Once these initial hangs were over and done with, the app would work normally.)
Inside the iPhoto Library Package, there are four SQLite databases (face_blob.db, face.db, iPhotoAux.db and iPhotoMain.db). I found that by vacuuming all four of these databases, I restored iPhoto ’09′s performance back to something on par with its predecessor.
Open Terminal and cd into your iPhoto Library (by default, cd ‘~/Pictures/iPhoto Library’). Once there, execute the following command:
for dbase in *.db; do sqlite3 $dbase "vacuum;"; done
Popularity: unranked [?]
Random Posts
Related posts (YARPP):
- Exploring the hidden features of the latest iPhoto update Exploring the hidden features of the latest iPhoto update: “The recent iPhoto 8.0.2 update includes several unheralded enhancements — some of them quite useful. Computerworld’s Ryan Faas explores the changes. (Via MacCentral.) ...
- Backing up Apple Mail’s Junkmail filter Folks, I normally recommend backing up the entire mail folder (~/library/mail), when you need to backup your Apple Mail… But what if you want to share your junk mail filter data to another computer? For example, your significant other’s computer… Copy the ~/library/mail/LSMMap2 file to the other computer, but don’t yet put it into [...]...
- where is apple mail emails stored? This topic was chosen from a Google search query that was passed on to the MDB… Apple Mail’s emails are stored in a unusual location… You would think, that since it is user created content, that they would be stored in ~Documents, but for some reason Safari Bookmarks, and Apple Mail are actually stored [...]...