Krazypoloc Wrote:Alright guys I got it all figured out (famous last words).

This is what I did and my music library is almost instantaneous. Commands to be pasted are in bold.

Code:

C:\Documents and Settings\Aaron>[b]mysql -u root -p xbmc_music[/b]
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.41 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> [b]CREATE INDEX test_idx ON song(idAlbum);[/b]
Query OK, 21514 rows affected (1.50 sec)
Records: 21514  Duplicates: 0  Warnings: 0

mysql> [b]alter table song add index idArtist(idArtist);[/b]
Query OK, 21514 rows affected (0.56 sec)
Records: 21514  Duplicates: 0  Warnings: 0

mysql> [b]alter table song add index idGenre(idGenre);[/b]
Query OK, 21514 rows affected (0.63 sec)
Records: 21514  Duplicates: 0  Warnings: 0

Thats for the music bit....I then added...

Code:

C:\Documents and Settings\Aaron>[b]mysql -u root -p xbmc_video[/b]
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 19
Server version: 5.1.41 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> [b]ALTER TABLE movie ADD INDEX ix_idFile(idFile);[/b]
Query OK, 680 rows affected (0.30 sec)
Records: 680  Duplicates: 0  Warnings: 0

I went to my bedroom system which is over WIFI and browsed to music, only too a second or two. Once inside music there is no delay selecting artists or albums. I queued up a high bitrate lossless (The Pacific Soundtrack) album to test the stability and speed and let it play. Then I went back to the root XBMC menu and went into movies, again only a second or two delay, I browsed movies without any issues, went back to TV Shows, ect, and back and forth without a single issue.

Hope this helps!

Also remember the commands above will only work if you have your mysql configured in your system path.

FreakinAye Wrote:Are you suppsoed to add sources to every frontend? My movies are duplicated and I can't figure out why. Cleaning does nothing.

My shows are tripled!

thaughbaer Wrote:Hi,
will I have issues with shared thumbnails if I have a mix of Linux and Windows clients or will it be ok as long as the source path is the same ?

Mike

Krazypoloc Wrote:Anyone have any idea how to fix these duplication issues?

Quote:| 3 | xbmc | P5QEM.lan:57396 | xbmc_video | Query | 308 | Sending data | select strPath,noUpdate from path where idPath in (select idPath from files join movie on movie.idFi |

sladinki007 Wrote:well it works pretty OK... once it is started but mine takes about 8 minutes to start

this is the query that slows the thing down



once this one is finished the the thing is up and running
tried optimizing my mysql settings but nothing much helps ....

any Mysql pro can make this query a bit easier to digest ?

my database has

26109 tv eps
3650 Movies
24647 Songs

nicely stored on an unraid with 18TB space

i already performed the above mentioned index changes (i was the one who asked for the video one, to the guy who posted it first )

so i guess now the only thing what is left is for XBMC to get better queries to optimize the speed ?

sladinki007 Wrote:well it works pretty OK... once it is started but mine takes about 8 minutes to start

this is the query that slows the thing down



once this one is finished the the thing is up and running
tried optimizing my mysql settings but nothing much helps ....

any Mysql pro can make this query a bit easier to digest ?

my database has

26109 tv eps
3650 Movies
24647 Songs

nicely stored on an unraid with 18TB space

i already performed the above mentioned index changes (i was the one who asked for the video one, to the guy who posted it first )

so i guess now the only thing what is left is for XBMC to get better queries to optimize the speed ?

hansdampf Wrote:i like this whole database on one server thing.

is it possible to decide which things are in sync?

i don`t want the watched status to be in the sql database, because in our network there are more people using the same movie server and it would be confusing for them.
on the other hand, on centralized database on the server would make the support for the users easier. i would be in total control over the movie database and make sure all movies get scraped right.

hansdampf Wrote:i like this whole database on one server thing.

is it possible to decide which things are in sync?

i don`t want the watched status to be in the sql database, because in our network there are more people using the same movie server and it would be confusing for them.
on the other hand, on centralized database on the server would make the support for the users easier. i would be in total control over the movie database and make sure all movies get scraped right.

TugboatBill Wrote:With that many items my suggestion would be to look into a fast SSD (SATA3 or PCIe) for your MySQL database.

sladinki007 Wrote:ok i put off scan on startup and now it only takes him like a minute or 2 to startup

response time is OK i guess
a few seconds to wait before a menu opens but i can live with that ...

difference between a normal database and the mysql is noticable ... the normal database is still a bit quicker in opening menu's
might be due to the skin i use... using transperancy .. and that loads a lot of images ... and the thumbnails is on the unraid ... all through gb network though and jumbo frames enabled

anyway couldn't do without the mysql with 2 htpc and 2 computers who regualary use xbmc in the house