mikerob Wrote:
>
> What debug information would be useful to find out what is going on?
No debug info needed any more. We already know what is going on.
There is a full database scan done in 6.2 in order to display the
statistic information on the start page (i.e. # of songs, albums,
artists).
I have shown a way to avoid this and still show the information, I
hope Dan Sully will chose to employ that scheme in a follow-up
version.
A temporary fix would be to edit %SLIMSERVER%/Slim/Web/Pages.pm at line
188-190 where it says:
$params->{'song_count'} = _lcPlural($ds->count('track',
$find), 'SONG', 'SONGS');
$params->{'artist_count'} = _lcPlural($ds->count('contributor',
$find), 'ARTIST', 'ARTISTS');
$params->{'album_count'} = _lcPlural($ds->count('album',
$find), 'ALBUM', 'ALBUMS');
Change those three lines to read:
$params->{'song_count'} = 0;
$params->{'artist_count'} = 0;
$params->{'album_count'} = 0;
By doing this, you lose the statistics on the start page but web access
is just as fast as before 6.2.
A little further up in the thread, I have also shown a tuning tip for
SQLite using PRAGMAs to speed up Slimserver database operations even
more but sacrificing some memory.
--
meyergru
_______________________________________________
Discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss
