Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the 'Speed up iPhoto '09 by vacuuming its databases' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Speed up iPhoto '09 by vacuuming its databases
Authored by: tilmansp on Mar 02, '09 09:36:33AM

Excellent! I suspected something like this all along, but with my limited Sqlite knowledge, I only got as far as rebuilding the indexes (which helped a little). Vacuuming makes a huge difference.

I enhanced the script a little to check that iPhoto isn't running. Save this into a file like vacuum_iphoto.sh, then make it executable, and you're all set:

#!/bin/bash
pid=`ps -ef | grep iPhoto | grep -v grep`
if [ "$pid" = "" ] ; then
cd ~/Pictures/iPhoto\ Library
for dbase in *.db; do sqlite3 $dbase "vacuum;"; done
else
echo "iPhoto is currently running. Please quit iPhoto before running $0."
fi



[ Reply to This | # ]