2010-03-24, 09:09
charrua Wrote:You can export the library from XBMC (settings>video>library>export video database-->only one file-->export thumbs and fanart) while still using the local (SQLite) database, and then import everything back from XBMC after making the change to the central (MySQL) database. That way you'll keep even the watched/unwatched info. The import process could take a while though (depending on the size of your library).
Thats awesome. I did not think of that. Its GREAT not having to rescrape
charrua Wrote:Regarding browsing speed using the central db, at least in my case, it's only a bit slower than using the local db. It's reasonable because MySQL db is remote and also natively slower than SQLite, but the advantages for the trade on speed are concurrency (simultaneous connections to the database) and native network connectivity.
Anyway if after importing all the data from the old db, you still have a very sluggish response from XBMC GUI, try enabling the debug mode and looking at the log to see if something unusual is happening and causing the problem. Alternatively you can post the log in the original thread of the feature posted before and ask for troubleshooting help.
Here its alot more sluggish now, but truth be told, i was playing with it mostly while scraping, which probably takes its toll both on xbmc aswell as MySQL, so im gonna try what you said and play with it after all my data is imported and see what results I get then.
One last thing. When setting up the rest of my Macs against this db, should I use separate MySQL logins with each or should I just duplicate the "advancedsettings.xml" that I allready created? Will MySQL accept several concurrent logins from the same user?
Thanks again for your help. You have made something that at first seemed VERY tecnical become comprehensive.