This query runs once a minute or so, and, well it sucks, creating huge
temporary tables all for what seems like a worthless statistic:
Code:
--------------------
SELECT COUNT( * ) FROM (SELECT me.id FROM tracks me WHERE ( me.audio = '1' )
GROUP BY me.id, me.url, me.content_type, me.title, me.titlesort,
me.titlesearch, me.album, me.primary_artist, me.tracknum, me.timestamp,
me.filesize, me.disc, 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.musicmagic_mixable, me.musicbrainz_id, me.lossless,
me.lyrics, me.replay_gain, me.replay_peak, me.extid) count_subq;
--------------------
Is there a reason for this? Almost all of those 'group by' items
seem useless for whatever this is trying to do...
--
snarlydwarf
------------------------------------------------------------------------
snarlydwarf's Profile: http://forums.slimdevices.com/member.php?userid=1179
View this thread: http://forums.slimdevices.com/showthread.php?t=66082
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
