vagskal;519502 Wrote: > The standard New Albums Costume Browse menu returns for me a menu with > thousands of albums, which chokes the SBS. Would it be possible to limit > the number of albums shown in that menu (like the option for the > original SBS menu New Music)? What would the code for such limitation > look like and where should it be inserted? >
It all depends why it's slow, it could be that the query takes time. However, if it's the amount of albums returned, you can add a "limit 50" to the SQL statement to limit the result to 50 albums. I should probably add a parameter for this in the template, feels like a useful option. The configuration would look something like this: Code: -------------------- <?xml version="1.0" encoding="utf-8"?> <custombrowse> <minslimserverversion>6.5</minslimserverversion> <menu> <menuname>Nya album</menuname> <menuorder>48</menuorder> <menu> <id>album</id> <menuname>Songs</menuname> <itemtype>album</itemtype> <itemformat>albumconcat</itemformat> <menutype>sql</menutype> <jivepattern>^(.*)\s\(([^,]+),?(.*)\)$</jivepattern> <menudata> select albums.id,if(albums.compilation,if(albums.year=0,' ',concat('(',albums.year,')')),concat(if(albums.year=0,'(',concat('(',albums.year,',')), group_concat(distinct contributors.name separator ',') ,')')) from tracks join contributor_track on tracks.id=contributor_track.track and contributor_track.role in (5) join contributors on contributor_track.contributor=contributors.id join albums on albums.id=tracks.album left join track_statistics on tracks.url=track_statistics.url where tracks.audio=1 group by albums.id order by max(track_statistics.added) desc limit 50 </menudata> <menu> <id>track</id> <itemtype>track</itemtype> <itemformat>track</itemformat> <playtype>all</playtype> <menutype>sql</menutype> <menudata> select tracks.id,tracks.title from tracks where tracks.audio=1 and tracks.album={album} order by tracks.disc,tracks.tracknum asc,tracks.titlesort asc </menudata> <menu> <id>trackdetails</id> <menutype>trackdetails</menutype> <menudata>track|0</menudata> </menu> </menu> </menu> </menu> </custombrowse> -------------------- -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=49483 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins