You are here: Home » Topic » SVN-1498 Soundbridge Problem

SVN-1498 Soundbridge Problem

This topic contains 11 replies, has 5 voices, and was last updated by  Anonymous 12 years, 10 months ago.

Viewing 12 posts - 1 through 12 (of 12 total)
  • Author
    Posts
  • #1061

    Anonymous

    Running NSLU unslung – serves up fine on iTunes client. My soundbridges however, have difficulty connecting. Once connected, “Browse Artists” fails with “Failed to Load Browse Data”. I have a large library (16,000 songs), so I tried several times to insure I wasn’t timing out. I’ve also created an index on artists to speed response time from sqlite.

    #8945

    CCRDude
    Participant

    If I read that correctly, indexes will only help when browsing deeper (all albums of one artist), not the full artist list.

    The only times I do experience such failures is when at the same time, I try to connect to the server in iTunes, somehow Firefly couldn’t handle multiple browsing connections in the last release. Are you trying to test the connection to iTunes at tthe same time you’re trying to browse?

    #8946

    Anonymous

    @ccrdude wrote:

    If I read that correctly, indexes will only help when browsing deeper (all albums of one artist), not the full artist list.

    The only times I do experience such failures is when at the same time, I try to connect to the server in iTunes, somehow Firefly couldn’t handle multiple browsing connections in the last release. Are you trying to test the connection to iTunes at tthe same time you’re trying to browse?

    If sqlite behaves as other relational engines do, then the Artist list would be served up completely from the index in pre-sorted order without having to read the underlying table. It’s called “index covering” The performance improvements are quite large in large tables. While I have lots of experience with commercial relational engines, I have no experience with sqlite.

    I only resorted to iTunes after my Soundbridge wouldn’t work. Actually, I tried it on 2 separate Soundbridges.

    #8947

    fizze
    Participant

    oh, on the contrary, indices will also speed up browsing ALL artists, because they speed up sorting. 😉
    But the improvement is more noticable, when browsing on ALL songs by a SINGLE artist.

    I guess you are hitting a timeout. Did you deunderclock your slug?
    What does

    cat /proc/cpuinfo 

    say?

    #8948

    Anonymous

    @fizze wrote:

    oh, on the contrary, indices will also speed up browsing ALL artists, because they speed up sorting. 😉
    But the improvement is more noticable, when browsing on ALL songs by a SINGLE artist.

    I guess you are hitting a timeout. Did you deunderclock your slug?
    What does

    cat /proc/cpuinfo 

    say?

    No, it’s not been de-underclocked. I’ve confirmed that it’s 133mhz. I may take a look at that. Though I also have to make serveral attempts to connect, which I didn’t have to do with the stable release I started with.

    #8949

    jheinitz
    Participant

    Hi,

    maybe there is a timeout problem in your environment. When you browse your library, could you please check if your FireFly Server is scanning the MP3 folder at the same time? Maybe the NSLU2 can not handle it all at the same time. I figured out that the whole NSLU2 become slow when the FireFly Server is performing a scan. I also discovered that setting the debuglevel to 9 increases the time to scan my MP3 folder. Actually it took longer than 10min and I configured the scan interval to be 10min so it scanned all the time.

    It’s just to give you some ideas where the problem can come from.

    Regards

    Jens

    #8950

    CCRDude
    Participant

    @pmorris wrote:

    If sqlite behaves as other relational engines do, then the Artist list would be served up completely from the index in pre-sorted order without having to read the underlying table.

    I guess that depends on the queries used? Doing a SELECT * FROM … wouldn’t have that advantage 😉 But indeed, I just tested, and my Soundbridge can access the DB much faster now 😯 Shiny 😮

    #8951

    Anonymous

    @ccrdude wrote:

    @pmorris wrote:

    If sqlite behaves as other relational engines do, then the Artist list would be served up completely from the index in pre-sorted order without having to read the underlying table.

    I guess that depends on the queries used? Doing a SELECT * FROM … wouldn’t have that advantage 😉 But indeed, I just tested, and my Soundbridge can access the DB much faster now 😯 Shiny 😮

    Yes, you’re absolutely right. Thank you for making that clarification. I should have said that any query whose result set can be satisfied by an index will experience faster performance.

    #8952

    rpedde
    Participant

    @pmorris wrote:

    Running NSLU unslung – serves up fine on iTunes client. My soundbridges however, have difficulty connecting. Once connected, “Browse Artists” fails with “Failed to Load Browse Data”. I have a large library (16,000 songs), so I tried several times to insure I wasn’t timing out. I’ve also created an index on artists to speed response time from sqlite.

    You might try fetching the list with firefox just to see if it parses right…

    something lik:

    http://server:port/rsp/db/1/artist

    should give you an xml list of the artists. If it doesn’t parse right, that’s the problem. Otherwise, it must be time, but I can’t imagine it would take all that long.

    Are you running on a particularly slow file system? Where is your /tmp mounted? If it’s on flash, can you try mounting a directory on your hard drive on tmp?

    #8953

    Anonymous

    @rpedde wrote:

    @pmorris wrote:

    Running NSLU unslung – serves up fine on iTunes client. My soundbridges however, have difficulty connecting. Once connected, “Browse Artists” fails with “Failed to Load Browse Data”. I have a large library (16,000 songs), so I tried several times to insure I wasn’t timing out. I’ve also created an index on artists to speed response time from sqlite.

    You might try fetching the list with firefox just to see if it parses right…

    something lik:

    http://server:port/rsp/db/1/artist

    should give you an xml list of the artists. If it doesn’t parse right, that’s the problem. Otherwise, it must be time, but I can’t imagine it would take all that long.

    Are you running on a particularly slow file system? Where is your /tmp mounted? If it’s on flash, can you try mounting a directory on your hard drive on tmp?

    That’s the strange thing: it’s serving up iTunes clients just fine. /tmp is mounted on a flash drive, but I don’t have any problem as long as I’m using iTunes to listen to music. I tried the URL you gave me and it works just fine: I get an xml list of the artists, though it takes a about 20 seconds. I suppose it could still be time; iTunes being more “patient” than Soundbridge.

    #8954

    fizze
    Participant

    Well, the soundbridge times out after 30secs. Maybe its different in some beta releases though *shrug*

    Occasionally I hit timeouts too, but not when my slug is otherwise idle.

    MAybe there’s some logging you can disable, to speed up firefly?

    #8955

    Anonymous

    Thank you to everyone for all of your assistance. I solved the problem, though I’m not sure what the problem was. First, I changed the MP3 directory to point to a single artist’s folder so I had a very small (14) number of songs. That worked perfectly. So, I changed the configuration to point to my entire MP3 library, deleted songs.db, rebooted the NSLU and restarted Firefly . . . . . and it worked.

    So now, I’ve got my little NSLU huffing and puffing (I’ve not clipped it’s little resistor yet) and serving up lots of great music. It’s still slow at loading my artist list (20 seconds)….and that’s with an index on artist and album, but that’s acceptable.

Viewing 12 posts - 1 through 12 (of 12 total)

The forum ‘Nightlies Feedback’ is closed to new topics and replies.