PasTim wrote:
>
> 1) Adjust process priorities in some way (but I note that change
> priorities in the Advanced, Performance menu has no effect on my linux
> system - they all run at priority 20)
>
I don't think this will help, from what I've seen the major issue is
when the SQLite needs to read information from the disk and CPU priority
won't make this any faster. I think there is some thread that explains
how to put the database on a ramdisk but I can't find it at the moment.
However, an issue with putting it on a ramdisk is that no changes (such
as TrackStat ratings) will be persisted.
PasTim wrote:
>
> 2) Apply some indexes to the custom tables in sqlite (is that possible,
> or is that only available in more complex sql system?)
>
This will likely result in the biggest improvements together with
optimising the SQL statements. However, I'm not sure how much it's
possible to improve it through indexes due to the data structure used by
Custom Scan, I think the main obstacle is that some tables join based on
text columns instead of integers and there isn't an easy solution for
this. Unfortunately, optimising the SQL statements is likely going to be
a lot of work.
PasTim wrote:
>
> 3) Spilt out music processing from menu processing in some way giving
> different runtime processes - I'm assuming the same perl process runs
> the menu processing and processing the music for playing
>
I don't think there is an easy way to do this.
PasTim wrote:
>
> 4) Find a way to run all my menus when the system starts up, or on
> command, so that all the data is loaded into memory (2 GB) and put up
> with the delay incurred just once, rather than when the mood takes me to
> use a different menu.
>
The problem with this is that it will work for a while, but eventually
it will throw away the information in the cache and become slow again.
PasTim wrote:
>
> If anyone has any suggestions I'd be keen to try them out.
>
I wonder if there might be some way to configure the OS caching so it
caches the database files in memory but still ensure that they are
persisted in the background. This would likely be the easiest way to
improve performance but I'm not sure if it's possible and how to do it,
maybe someone else reading this knows ?
It looks like I have a database dump from your setup from beginning of
2012 and also a works by composer menu configuration. Do you remember if
the problem was the same at that time or if it's something that have
started to appear later ?
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
