Go to advanced search

by SoundBridgeUser
Sat Jun 16, 2018 1:55 pm
Forum: Raspbian
Topic: Improved forked-daapd (iTunes server)
Replies: 1512
Views: 366999

Re: Improved forked-daapd (iTunes server)

Hi - I have some better news now. I haven't done anything, but my smart playlists are now playing. I'm not sure what the analyse command did, but things are working better than they have ever been :D .

Many thanks for your assistance with this.

Richard
by SoundBridgeUser
Sat Jun 16, 2018 8:15 am
Forum: Raspbian
Topic: Improved forked-daapd (iTunes server)
Replies: 1512
Views: 366999

Re: Improved forked-daapd (iTunes server)

Hi, Thanks for your response - I really appreciate the time you are spending on this. I have some good news and bad news. Here is the output from what you have asked to do: $ sudo sqlite3 /var/cache/forked-daapd/songs3.db SQLite version 3.16.2 2017-01-06 16:32:41 Enter ".help" for usage hints. sqlit...
by SoundBridgeUser
Thu Jun 14, 2018 9:13 pm
Forum: Raspbian
Topic: Improved forked-daapd (iTunes server)
Replies: 1512
Views: 366999

Re: Improved forked-daapd (iTunes server)

Hi,

Deleting the index doesn't appear to make a difference - the query plan results are the same as before.

Recreating the index also gives the same results.

Cheers,

Richard
by SoundBridgeUser
Thu Jun 14, 2018 5:50 pm
Forum: Raspbian
Topic: Improved forked-daapd (iTunes server)
Replies: 1512
Views: 366999

Re: Improved forked-daapd (iTunes server)

Hm, looks like sqlite3 is using a very suboptimal query strategy on your device. With that strategy it would be processing pretty much all rows in the files table for each playlist, which would indeed be very slow (200 x 47.000). I can't figure out why sqlite is doing that... a possibility is that ...
by SoundBridgeUser
Wed Jun 13, 2018 9:49 pm
Forum: Raspbian
Topic: Improved forked-daapd (iTunes server)
Replies: 1512
Views: 366999

Re: Improved forked-daapd (iTunes server)

Hi, Thanks for your quick response. I only have 26.1 installed - not sure how best to rollback to 26.0. I ran the commands - the .load command didn't work as you wrote it, as the file "forked-daapd-sqlext.so" was in a different location (I had to search for it). Running the commands produced slightl...
by SoundBridgeUser
Wed Jun 13, 2018 8:28 pm
Forum: Raspbian
Topic: Improved forked-daapd (iTunes server)
Replies: 1512
Views: 366999

Re: Improved forked-daapd (iTunes server)

I've made some database index and query changes, actually also to help with RSP response times. I don't think I did anything related to playlists, but maybe I did. Can you say what the previous version you were using was? Then I can compare db performance. There is so much you can do on your side. ...
by SoundBridgeUser
Tue Jun 12, 2018 7:17 pm
Forum: Raspbian
Topic: Improved forked-daapd (iTunes server)
Replies: 1512
Views: 366999

Re: Improved forked-daapd (iTunes server)

Hi, First of all, I'm a complete newbie to this forum, but I have been using forked-daapd for 18 months now on a Raspberry PI and used the original Firefly / mt-daapd on an NSLU2 for about 10 years before. I use forked-daapd on a Raspberry PI 3 to serve to a small number of Roku Soundbridges (I have...

Go to advanced search