Slowness on large libraries - workarounds and ideas

  Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
marantz Offline
Senior Member
Posts: 209
Joined: Feb 2014
Reputation: 3
Post: #16
@DaveBlake , do you also have my db in mysql? even in lan it takes a while to retrieve, have you tried this?
find quote
DaveBlake Offline
Team-Kodi Member
Posts: 2,439
Joined: Jun 2015
Reputation: 68
Location: South West England
Post: #17
Yes thanks @marantz, it is a great test resource Smile
I have a version migrated from Jarvis, although I did wonder if you had ever scanned from scratch to create a new v60. And yes I have tried various things with it, including trying to convert to SQLite to compare perfromance. I have been looking for a convertion tool (MySQL -> SQLite), did some of it manually and that was tedious. The quotes in text field data are tricky.

When you say "even in lan it takes a while to retrieve" what do you mean exactly? I know it is slow, not doubting that, but not so clear on the lan comment. Of course although testing with MySQL I have it locally not on a separate server, so I am not seeing network effects. That can only make things worse.
find quote
Post Reply