Optimize db files of XBMC+Addons

[namtih]

This will search for db files in the xbian folder and will optimize those databases. This requires the sqlite3 binaries.
Could be handy when you have a big database and/or made many changes. As it just reorganize/rebuilt the databases and doesn't delete any data, it should be safe to use.

Terminal

sudo apt-get update
sudo apt-get install sqlite3
sudo /etc/init.d/xbmc stop

for i in `find /home/xbian -iname "*.db"` ; do sudo /usr/bin/sqlite3 $i 'VACUUM;' ; sudo /usr/bin/sqlite3 $i 'REINDEX;' ; done

sudo /etc/init.d/xbmc start

Perhaps something for the xbian-config tool like a kind of "housekeeping" task? ;-)

[mad-max]

Do you have ans timings before and after indexing?

[namtih]

No, unfortunately not.
I have only a very small movie database at the moment due some re-installations. So I can't make a real test for now.

But perhaps another user will make a short comment here.