Quote:
Originally Posted by creeva
I moved over to using a MySQL database where all the XBMC instances share the same library.
The only real advantage I have with using MySQL (in what actually works for me) is that I only have to scrape the media once and then it is available to all my machines.
|
To expand on using a MySQL database, the covers and such used in XBMC are placed on a share (SMB/CIFS/NFS/etc) so that if one system updates them, the change is available immediately to all systems.
Beyond being able to share your same database information and cover/content files, MySQL offers much greater speed when working with a large number of entries. We're talking an order of magnitude faster. There is just no practical way to design an embedded relational database like SQLite to have the performance of a dedicated relational database when you're dealing with a lot of data.
My ideal would be to have a central file store with a MySQL database that all of my families computers could access. And when they want to be on the go with a particular book, copy the book to their local library. That way their local libraries are small (and so fast), while the main library is large but still fast because of the full database system.