I think the problem is that user slimserver doesn't seem to alllow a
normal login (or switch). I used your alternative suggestion though
(cheers). The results are:
These lines:
Code:
--------------------
060701 23:52:34 2 Query SELECT COUNT( DISTINCT( me.id ) ) FROM
tracks me
2 Query SELECT LEFT(me.titlesort, 1), COUNT( DISTINCT(me.id) ) FROM
tracks me GROUP BY LEFT(me.titlesort, 1) ORDER BY me.disc, me.tracknum,
me.titlesort
060701 23:52:35 2 Query SELECT me.id, me.url, me.content_type,
me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp,
me.filesize, me.tag, me.disc, me.thumb, me.remote, me.audio, me.audio_size,
me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate,
me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian,
me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable,
me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed,
me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks
me GROUP BY me.id ORDER BY me.disc, me.tracknum, me.titlesort LIMIT 123
--------------------
then this repeated lots:
Code:
--------------------
060701 23:52:37 2 Query SELECT contributor.id, contributor.name,
contributor.namesort, contributor.moodlogic_id, contributor.moodlogic_mixable,
contributor.musicmagic_mixable, contributor.namesearch,
contributor.musicbrainz_id FROM contributor_track me JOIN contributors
contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role = '1' ) AND
( me.track = '6466' ) ) )
--------------------
...then this line:
Code:
--------------------
2 Query SELECT me.id, me.url, me.content_type, me.title, me.titlesort,
me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.tag,
me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset,
me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate,
me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm,
me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable,
me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed,
me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks
me GROUP BY me.id ORDER BY me.disc, me.tracknum, me.titlesort
--------------------
...followed immediately by this:
Code:
--------------------
2006-07-01 23:53:16.8150 Response Time > 0.5 : 42.0837411880493
2006-07-01 23:53:16.8437 Timer Late > 0.5 : 41.6104979515076
2006-07-01 23:53:16.9167 Timer Late > 0.5 : 41.4153969287872
--------------------
...then lots of these two lines repeated:
Code:
--------------------
060701 23:53:20 2 Query SELECT me.id, me.titlesort,
me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc,
me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak,
me.musicbrainz_id, me.title FROM albums me WHERE ( ( ( me.id = '281' ) ) )
060701 23:53:21 2 Query SELECT contributor.id, contributor.name,
contributor.namesort, contributor.moodlogic_id, contributor.moodlogic_mixable,
contributor.musicmagic_mixable, contributor.namesearch,
contributor.musicbrainz_id FROM contributor_track me JOIN contributors
contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role = '1' ) AND
( me.track = '3092' ) ) )
--------------------
...and finishing like this:
Code:
--------------------
2006-07-01 23:53:56.7377 Web Page Build > 0.5 : 82.0052690505981
2006-07-01 23:53:56.7384 Generating page for browsedb.html
2006-07-01 23:53:56.7705 Select Task > 0.5 : 82.1892721652985
2006-07-01 23:53:56.7769 Slim::Web::HTTP::processHTTP
060701 23:53:57 2 Query SELECT me.id, me.track, me.value FROM
comments me WHERE ( me.track = '6477' )
2 Query SELECT contributor.id, contributor.name, contributor.namesort,
contributor.moodlogic_id, contributor.moodlogic_mixable,
contributor.musicmagic_mixable, contributor.namesearch,
contributor.musicbrainz_id FROM contributor_track me JOIN contributors
contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role = '1' ) AND
( me.track = '6477' ) ) )
2006-07-01 23:53:57.4387 Select Task > 0.5 : 0.660239934921265
2006-07-01 23:53:57.4394 Slim::Web::HTTP::processHTTP
--------------------
Does that help?
Cheers,
Richard
--
SadGamerGeek
------------------------------------------------------------------------
SadGamerGeek's Profile: http://forums.slimdevices.com/member.php?userid=6145
View this thread: http://forums.slimdevices.com/showthread.php?t=24990
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
