Optimize db files of XBMC+Addons
|
23rd Mar, 2013, 05:08 AM
Post: #1
|
|||
|
|||
Optimize db files of XBMC+Addons
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? ;-) |
|||
23rd Mar, 2013, 07:59 AM
Post: #2
|
|||
|
|||
AW: Optimize db files of XBMC+Addons
Do you have ans timings before and after indexing?
|
|||
23rd Mar, 2013, 06:07 PM
Post: #3
|
|||
|
|||
RE: Optimize db files of XBMC+Addons
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. |
|||
« Next Oldest | Next Newest »
|