macosxhints.com - Speed up iPhoto '09 by vacuuming its databases
http://www.macosxhints.com/article.php?story=20090227072825458

for dbase in *.db; do sqlite3 $dbase "vacuum;"; done

Deserve a try