Co1;639784 Wrote: > > However, with the patch, that I have sent earlier, applied on > 2.8.3363: > Beethoven>Piano takes 4.3 s, > JS Bach>Cantatas, takes 4.9 s > > If there is no difference in your setup from the patch, maybe the > library content plays a role. I have 4600 tracks, 35 genres, only 144 > artists. I have a Classical and Pop (multi)library, 4240/360 tracks > respectively. Many albums are <no artist>, because I only use the > artist tag for soloists. In Squeezebox server the artist tag gets > special treatment. Could this be the cause for the differences? I could > run an experiment in the weekend where I will mess up my tagging to fill > the artist tags with Composers, and Conductors. Could you try if it works better with the latest Multi Library (2.5.3369) which I just released ?
It runs ANALYZE on the multilibrary tables so if that was the issue this should solve it. I still don't see any performance change with and without the patch in my own library. If this doesn't help, does it help if you connect towards the squeezebox.db and squeezebox-persistent.db files with a SQLite client and run ANALYZE. Does the patch make difference also after that ? Which interface do you test the performance in ? Is it the web interface or some other interface ? Also if you have the time and you have a specific test installation of SBS, try with one of the large database dumps I posted about in the following thread and see if the patch makes difference in that library in your setup. Note, only do this if you have a specific test setup, you do NOT want to use these test libraries in your normal SBS setup as it can create a mess in your TrackStat and Custom Scan data. http://forums.slimdevices.com/showthread.php?p=640020#post640020 The flac50000.zip file contains a random generated FLAC library with very small FLAC files. Unzip this and point the SBS Music Folder to the unzipped directory and perform a full rescan and then try how the browsing performs. This library contains 4080 albums with 49808 songs and 3322 artists. -- erland Erland Isaksson ('My homepage' (http://erland.isaksson.info)) (Developer of 'many plugins/applets' (http://wiki.slimdevices.com/index.php/User:Erland). If my answer helped you and you like to encourage future presence on this forum and/or third party plugin/applet development, 'donations are always appreciated' (http://erland.isaksson.info/donate)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=88627 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
