+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Discussions (https://forum.kodi.tv/forumdisplay.php?fid=222)
+--- Forum: Kodi related discussions (https://forum.kodi.tv/forumdisplay.php?fid=6)
+--- Thread: Speed of MySQL database on server vs local (/showthread.php?tid=152518)
Speed of MySQL database on server vs local - Rick P. - 2013-01-18
I currently have 3 machines running XBMC. Each currently has its own database that I keep more or less up to date but one, an Acer Revo Aspire, is slow scraping and especially opening and sorting my music library. I don't recall the actual number but my music library has something in the order of 85,000 tracks. My server's something of a beast with plenty of RAM and i have a fast network so I'm pretty sure it could serve data faster than the Revo could sort it out. On the other hand my everyday TV HTPC has a fast CPU, SSD and also more RAM than necessary so it can rip through stuff very quickly, including the music library.
Question is, would XBMC's performance using a common SQL database be noticeably different on my everyday HTPC if I did so? The server also has a SSD the database would be stored on, and I would likely cache the entire database in RAM. Thoughts?
RE: Speed of SQL database on server vs local - Ned Scott - 2013-01-18
Just to clear this up:
MySQL - network
SQL - local, what XBMC already uses normally
MySQL will always be slower because your accessing it over the network. I personally do not notice the slowdown.
RE: Speed of SQL database on server vs local - Rick P. - 2013-01-18
(2013-01-18, 05:31)Ned Scott Wrote: Just to clear this up:
MySQL - network
SQL - local, what XBMC already uses normally
MySQL will always be slower because your accessing it over the network. I personally do not notice the slowdown.
Right - it is MySQL I'm running on the server (just being thrifty with my letters...). I assumed the fast computer would take a bit of a performance hit but I had no idea how much. How big is your database?
I don't know anything about the MySQL server other than how to install it but assume XBMC sends the query to the server which runs it and returns the results back to XBMC. In this case the network solution should be faster than local results on the Revo, which isn't particularly fast and has a relatively slow hard drive. Does this sound right? Thx
RE: Speed of SQL database on server vs local - Ned Scott - 2013-01-18
I personally have a fairly small library of about 300 movies.
RE: Speed of SQL database on server vs local - nsviper - 2013-01-18
All my media (about 260 HD movies, 2500 HD TV episodes, and about 4500 mp3 audio files) are stored on my QNAP NAS TS410. The NAS also has MySQL running it on for my central DB for my ATV's and RPi.
The TS410 spec is only a meagre Marvel 800MHz CPU with 256MB of DDR2 Memory.
With Frodo RC3 installed it all runs fine for me - no noticable difference between local DB on the ATV's and the MySQL central setup.
(Everything is on wired Solwise powerline adapters - rated at 200Mb - monitoring SW for then show then running at approx 160-180 Mb)
RE: Speed of SQL database on server vs local - aptalca - 2013-01-19
It depends greatly on the connection speed to the server
With gigabit, I do not notice any difference between local vs mysql
However, 100Mbit/s is slower, wifi N is even slower, wifi G is too slow for my taste and powerline is between 100Mbit and wifi N/G depending on reception
Anything less than gigabit connection, I notice a delay in entering the library. I have a decent sized library with close to 1000 movies. on wifi G it takes up to 15-20 seconds to enter
RE: Speed of SQL database on server vs local - Rick P. - 2013-01-19
Thanks guys. I have a gigabit network so i think my transfer speeds are as good as you'd see in a house. I've also got about 1000 movies and they come up immediately. It's the music library where things slow down for me on the Revo and this is where I'd like to be able to speed things up. I think my database file is currently about 3.5 GB.