[charrua]

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 have almost 2000 movies in my library, plus more than 3500 tv show episodes, plus more than 2000 musicvideos. XBMC takes only a couple of seconds to load the movie library (similar time for tv shows and a bit more for musicvideos) it is a little slower than using the local db, but not too much. Probably you have a particular problem that is causing the sluggishness you describe. As suggested before set XBMC in debug mode and analize the log or post it in the forum for others to analize and try to find the cause of the problem.