gharris999;626012 Wrote:
>
> Reboot the server, wait 2 minutes. Open a CLI session to SBS. Perform
> a "tracks 0 500 new" query. CLI query returns after about 50 seconds.
> Open the SBS webUI and go to "My Music" -> "New Music". New music page
> displays after a 3 second wait.
>
I believe SBS uses some caching so some of the queries takes a lot
longer time the first time after a rescan compared to the second time
they are executed.
Looking at the code, it looks like 7.5 and 7.6 handles this
differently, 7.5 seems to only cache JSON(SqueezePlay) queries while
7.6 caches on DBI level which affects all queries independent if they
are called from Web interface, CLI, IP3K or SqueezePlay.
Still, if the "New Music" query takes 50 seconds the first time it
feels like someone should take a look at the code and database indexes.
Is it only the "New Music" query that takes this long or does it also
affect the standard "Albums" menu ?
--
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=87070
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
