[noumenon]

Allright, Ive got everything up and running now. This is a killer feature imo. Really sets XBMC apart from Plex and the rest of the competition. Whats bothering me though is how sluggish XBMC becomes using this. It takes about 20 seconds from i push the remote until the movie library opens. The same goes for the TV library.

Im guessing there must be some tweaks I can do to MySQL to improve this. Im on gigabit lan and the computer running the SQL server is a Quad Core 3 GHZ with 8 gigs memory on Vista 64, so clearly the hardware shouldnt be a limitation. As for network, Im on gigabit and ive shared the library over network before using symlinks, and that hardly caused a delay at all.

Anyone here with similar situations whos found a sollution?

I'm having the exact same problem. My mac to linux server is nice and snappy, but my linux htpc to my linux server is exactly as you describe... 20 or so seconds on every directory change.

I tried logging long query times with a limit of 2 seconds, but nothing showed up in the log. The xbmc log doesn't seem to show any errors concerning the databases either. Just says that it is accessing them with several seconds elapsing after it starts until the next item is logged.




noumenon


edit: sorry for the double post... they are different topics though... kinda