+- Forum (http://forum.xbian.org)
+-- Forum: Software (/forum-6.html)
+--- Forum: Testing & Experimental (/forum-21.html)
+--- Thread: Optimize db files of XBMC+Addons (/thread-665.html)
Optimize db files of XBMC+Addons - namtih - 23rd Mar, 2013 05:08 AM
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? ;-)
AW: Optimize db files of XBMC+Addons - mad-max - 23rd Mar, 2013 07:59 AM
Do you have ans timings before and after indexing?
RE: Optimize db files of XBMC+Addons - namtih - 23rd Mar, 2013 06:07 PM
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.