2011-11-18, 23:16
sabotage Wrote:I'd just like to add my voice into the discussion. I have the atv2 and would like to use this contribution. I read here in the thread regarding the speed issue with SQL. Looking forward to any information to improve performance.
I understand that some users are running external database to support multiple devices. If the database is on the atv2, is there still an issue?
I put a local DB on my atv2 to do a comparison. Performance increase is 15 seconds for my 1500 episodes, with the total result presented in 40 seconds.
http://pastebin.com/uQmb23L6
Edit: comparing with the debug from mysql http://pastebin.com/wbUnCBg8 I find it hard to see where the performance increase actually is coming from, for example the first request with local DB:
DEBUG: RunQuery took 344 ms for 53 items query: SELECT * FROM tvshowview
with MySQL:
RunQuery took 96 ms for 53 items query: SELECT * FROM tvshowview