PasTim wrote:
>
> The one thing that worked was dropping and recreating an index in your
> dbindex.sql (I don't think it matters much which one - I chose
> module_attr_valuesort_cstrackidx since a value is needed on all rows,
> and the sort version is used for sorting as well) . However, this adds
> around 7 minutes to the startup time. I have therefore re-evaluated how
> I manage the power saving on my Vortexbox. I will 'suspend' the box
> after an hour of idle, rather than 'hibernate' (which gave me odd sound
> problems after a few restarts) or shutdown. Suspend seems to keep the
> cache, at least for a while. I'll just have to start the box 1st thing
> in the morning when I'm not using it immediately.
>
> I don't know how quickly the cache will 'drain', but will try this for a
> few days and see how it goes.
>
As you suspect, dropping and recreating an index will likely load the
database into the in-memory cache and this is the reason why it improves
the performance. I don't think I can introduce this as standard as
having a startup time of several minutes would make the system more or
less useless for other people, especially people who use the alarm
functionality and wake up the server through wake on lan before the
alarm is about to trigger.
There could be ways to optimise the menu SQL in your particular
configuration, but I need to get some time to look at it in my own
environment to know for sure.
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets (both free and commercial)'
(http://wiki.slimdevices.com/index.php/User:Erland).
If you like to encourage future presence on this forum and/or third
party plugin/applet development, 'consider purchasing some plugins'
(http://license.isaksson.info))
You may also want to try my Android apps 'Squeeze Display'
(https://play.google.com/store/apps/details?id=info.isaksson.squeezedisplay)
and 'RSS Photo Show'
(https://play.google.com/store/apps/details?id=info.isaksson.rssphotoshow)
*Interested in the future of music streaming ? 'ickStream - A world of
music at your fingertips'
(http://forums.slimdevices.com/showthread.php?98467-Pre-Announcement-ickStream&p=743516)*.
------------------------------------------------------------------------
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
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
