+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Help and Support (/forumdisplay.php?fid=33)
+--- Forum: XBMC General Help and Support (/forumdisplay.php?fid=111)
+---- Forum: Windows support (/forumdisplay.php?fid=59)
+---- Thread: 2 XBMC PCs and 1 Database on the shared NAS (/showthread.php?tid=70603)
- castortray - 2011-02-18 17:02
tboooe Wrote:Did you add the index to mysql?
nope,
I'm not good in SQL,
I would be grateful If you helped me with the command
CREATE INDEX ...
thx
- boulala - 2011-02-18 22:54
so well now i came around and could finally try some of the solutions you guy suggested.
the main problem with the slow interface was absolutly my fault, because the connection to the mysql couldn't be established. so thats fixed. know i have the thing that when i open the music or video library/folder it takes some time to load the library even if i don't have any movies or music files in the library. any suggestions on that one? guess the index thingy could solve that problem for the music library but how about the movie library?
PS: could try the resolve-name conf. because i couldn't finde out how to do it. gone ask my friend google and his brother bing if they can help me
- tboooe - 2011-02-18 23:30
boulala Wrote:so well now i came around and could finally try some of the solutions you guy suggested.
the main problem with the slow interface was absolutly my fault, because the connection to the mysql couldn't be established. so thats fixed. know i have the thing that when i open the music or video library/folder it takes some time to load the library even if i don't have any movies or music files in the library. any suggestions on that one? guess the index thingy could solve that problem for the music library but how about the movie library?
PS: could try the resolve-name conf. because i couldn't finde out how to do it. gone ask my friend google and his brother bing if they can help me
Just add "skip-name-resolve" in your mysql ini file in the mysqld section.
As for library slowness...try the indexes.
- avus m3 - 2011-02-19 02:28
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 which works great. 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?
- buges - 2011-02-19 09:22
@ avus m3 No problems here with movie sets added a few last night all working fine. Don't know if this helps you, but im running mysql v5,1,41 on ubuntu. It should'nt make any difference being linux or win, but you never know.
xbmc r35744
- boulala - 2011-02-19 19:44
Quote:Just add "skip-name-resolve" in your mysql ini file in the mysqld section.
As for library slowness...try the indexes.
Sorry i still don't get it. have to browse the net a little bit. sure gone find some info on that one.
i already added the indexes. will see if it still runs smooth when i import some files.
thanks anyway for all the help
- darkscout - 2011-02-19 20:18
16000 actors.
Took 4 seconds.
- gundam83 - 2011-02-19 21:41
This may sound like a stupid question as I haven't fully tackled XBMC yet, but it'll be perfectly fine if I stored all my movies on a server, and have my htpc clients keep their own databases/thumbs/info/etc correct? All of this mySQL database stuff is making my head spin, plus I don't like the idea of slowing down library access. The only drawback is wasting a few extra seconds updating thumbs/info for each client right?
- tboooe - 2011-02-19 22:17
gundam83 Wrote:This may sound like a stupid question as I haven't fully tackled XBMC yet, but it'll be perfectly fine if I stored all my movies on a server, and have my htpc clients keep their own databases/thumbs/info/etc correct? All of this mySQL database stuff is making my head spin, plus I don't like the idea of slowing down library access. The only drawback is wasting a few extra seconds updating thumbs/info for each client right?
yup, this is the standard way and you will probably be pretty happy with this setup. For some, there is no slow down at all. For me, the benefits are worth it. Keeping playcount, play position, thumbs etc synced between multiple clients is very convenient. Try it out and see what you think.
- castortray - 2011-02-20 00:23
darkscout Wrote:16000 actors.
Took 4 seconds.
how did you do that ? (just add skip-name-resolve to my.ini ? )
Are you use SSD ? Where you have MySQL installed ?
Mine is on Windows 7 (ASRock ION 330HT)