MrDVD Wrote:You did this commands at an MySQL Admin tool ? (like Heidisql)

Music:

Code:

CREATE INDEX idAlbum_idx ON song(idAlbum);
CREATE INDEX idArtist_idx ON song(idArtist);
CREATE INDEX idArtist_idx ON album(idArtist);
CREATE INDEX idArtist_idx ON exartistsong(idArtist);
CREATE INDEX idArtist_idx ON exartistalbum(idArtist);
ALTER TABLE xbmc_music.song ADD INDEX idx_idArtist(idArtist);
ALTER TABLE xbmc_music.song ADD INDEX idx_idGenre(idGenre);
ALTER TABLE xbmc_music.song ADD INDEX idx_idAlbum(idAlbum);

Movie:

Code:

ALTER TABLE movie ADD INDEX idMovie(idMovie);
ALTER TABLE movie ADD INDEX idFile(idFile);

Here it helped a lot.

Edit:
You also try to change the cache size that mysql use:

Code:

set global query_cache_size = 10000000;

blademansw Wrote:I have about 100 movies, 60 TV shows but 16,000 songs with shared thumbs

That works fine, the only thing that is slow is when you go into music by artist view - very slow, however, on the XBMC android remote by artist view, its fast. Work that one out!

(2012-04-21 08:24)pctech Wrote:  Hello Xbmc Members....

I have blown peoples minds with this xbmc software, But I have a question about network streaming from a server to xbmc boxes on my network.i would like to know what is the best way to stream my collection of movies and music from a network server and send this stream to family members online(people with internet connection)