2017-01-02, 19:03
Split from other tread as spearate topic
When you say "huge genres" you mean 3k of song files? The performance issue with any long list in playlists or nodes especially songs is well known, and it actually isn't the database that is the problem but what Kodi does with the data having fetched it. It is being looked into but does require substantial redesign work.
Benchmarking - not as I know of, although people have timed their system here and there. As you realise LAN speeds make a difference as well as processer power and disc access speed (or wherever the music files are)
(2017-01-01, 17:59)Rusendusen Wrote: I've got a huge collection speaking of a 125MB database file within mysql. It's slow, although connected with gigabit lan. I make use of 'similar tracks' for last.fm a lot having the possibility to find similar music to the one that is playing just now within my own collection. It takes quite a time with local db but with mysql it's slow. Is there a way to fasten db queries by doing some indexing? Even adding huge genres (3k files) into a playlist is not what I call performance. I would expect a speed bonus for db in comparison to filesystem. Adding 3K lines of text into a playlist is a simple copy paste. Could having the playlist be a db file or a table itself enhance this in regards to performance as it's only a query? I don't have to fear missing tracks within a playlist as I keep the db up2date.Lastfm - I assume that is using some addon? I would guess it is doing something inefficient querywise, but only what is possible for a script via JSON API. But I emphasise guess, you need to discuss it with the addon author.
Is there a db query for kodis musicdb that's able to measure system's performance and make it comparable? A benchmark?
When you say "huge genres" you mean 3k of song files? The performance issue with any long list in playlists or nodes especially songs is well known, and it actually isn't the database that is the problem but what Kodi does with the data having fetched it. It is being looked into but does require substantial redesign work.
Benchmarking - not as I know of, although people have timed their system here and there. As you realise LAN speeds make a difference as well as processer power and disc access speed (or wherever the music files are)