Posts: 2
Joined: Jan 2011
Reputation:
0
I have about 1400 videos in my movie library and about 5000 tv episodes. It's pretty slow to load the initial list of movies/tv shows. Do you guys have any reccos for improving tv/movie performance with indexes to create?
Posts: 90
Joined: Oct 2008
Reputation:
0
you should have a look over the queries and set some indizes, this should speed things up.
episodeview and movieview seem like good candidates.
Posts: 19
Joined: Dec 2010
Reputation:
0
TiGmsm
Junior Member
Posts: 19
Hello,
An xbmc newbie here and I'm having trouble getting this to work with two instances of xbmc installed on Windows 7 (my laptop and my desktop) are using the mySQL database, the shared aspect is missing an any noticeable way.
I have checked every setting that I can find in the GUI but for the life of me cannot find how the two machines are sharing any data. I can see that both machines hit the mySQL database using mySQL Workbench. Both machines show connections to the same database when expected (xbmc_video when accessing movies).
The very least of what I expect to see but do not is "watched" status in common between the two machines.
I am also not seeing any of the following:
1. Both machines show the the same sources where I added the source to only one of the two.
2. Paused status for any particular movie on one instance show in some meaningful way on the other.
I suspect there is some fundamental setting that I am missing. Anyone have any tips that might help track down this problem?
Thanks!
-Bob
Posts: 132
Joined: Mar 2009
Reputation:
0
I would greatly appreciate if someone with good Mysql knowledge could write up a quick guide on how to set up indexing to speed up the SQL XBMC video database.
Posts: 245
Joined: May 2010
Reputation:
0
Is anyone having issues creating movie sets once switched over to SQL? I created one set that was imported into the SQL DB a long time ago. I have recently tried creating other sets (like all the Bond movies) and when the movies are added into the DB the set info is ignored or something?