Multi-Library/Custom Browse slow?

[milowg]

I have recently installed the Multi-Library and Custom Browse plugins in order to seperate out my children's music from the rest of my music. What I want to do is be able to look at "New albums", "Artist", etc only in one library.

What I have set up are two Libraries, one with Genre "Baby" and one without Genre "Baby"

What I've found is that the load time of the menus on my Squeezebox Duet Controller are very slow. For example, when I click on Main->Artists, it takes about 3-5 seconds to get the list of artists. When I do this using my old Music Libary->Artists menu it takes under 1 second.

When I run the SQL through MySql Query Browser, it only takes 1 second or so.

Has anyone else seen this slowness? Could it be something in the plugin code?

[erland]

Custom Browse is known to run a bit slower than standard browse menus, one reason for this is that it runs more complex SQL statements towards the database than what the the standard browse menu does.

I think it will run several SQL statements when you enter the "Artists" menu, so even though one of them takes 1 second the others might cause it to be a few seconds on the Controller.

Patches are always welcome if someone finds a way to optimize the code.

[milowg]

Well, I solved the long wait time for New Albums by adding "limit 0, 15" to the SQL statement to only return the top 15 newest albums. This cut down my wait from about 12 seconds to 1.

I will take a look at the SQL and Perl for the Artists menu and see if I can find anything to optimize it.

Thanks by the way for making these plugins, they are really useful!