After setting database.sql logging to Info, this is what I see.
I think these lines launchi the "text search" query:
Code:
--------------------
Slim::Schema::Debug::query_start (22) SELECT COUNT( * ) FROM (SELECT me.id
FROM tracks me LEFT JOIN genre_track genreTracks ON genreTracks.track = me.id
WHERE ( ( genre IN ( SELECT me.id FROM genres me WHERE ( ( me.namesearch LIKE ?
OR me.namesearch LIKE ? ) ) ) AND me.audio = ? ) ) GROUP BY me.id) count_subq:
'%ROCK%', '%JAZZ%', '1'
Slim::Schema::Debug::query_start (22) SELECT me.id, me.urlmd5, me.url,
me.content_type, me.title, me.titlesort, me.titlesearch, me.album,
me.primary_artist, me.tracknum, me.timestamp, me.added_time, me.updated_time,
me.filesize, me.disc, me.remote, me.audio, me.audio_size, me.audio_offset,
me.year, me.secs, me.cover, me.cover_cached, 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.dlna_profile,
me.musicbrainz_id, me.lossless, me.lyrics, me.replay_gain, me.replay_peak,
me.extid, me.virtual, me.coverid FROM tracks me LEFT JOIN genre_track
genreTracks ON genreTracks.track = me.id WHERE ( ( genre IN ( SELECT me.id FROM
genres me WHERE ( ( me.namesearch LIKE ? OR me.namesearch LIKE ? ) ) ) AND
me.audio = ? ) ) GROUP BY me.id ORDER BY me.disc, me.titlesort COLLATE en_US
LIMIT 50: '%ROCK%', '%JAZZ%', '1'
--------------------
while these appear to start the "not in text search" query:
Code:
--------------------
Slim::Schema::Debug::query_start (22) SELECT COUNT( * ) FROM (SELECT me.id
FROM tracks me LEFT JOIN genre_track genreTracks ON genreTracks.track = me.id
WHERE ( ( genre NOT IN ( SELECT me.id FROM genres me WHERE ( ( me.namesearch
LIKE ? OR me.namesearch LIKE ? ) ) ) AND me.audio = ? ) ) GROUP BY me.id)
count_subq: '%ROCK%', '%JAZZ%', '1'
Slim::Schema::Debug::query_start (22) SELECT me.id, me.urlmd5, me.url,
me.content_type, me.title, me.titlesort, me.titlesearch, me.album,
me.primary_artist, me.tracknum, me.timestamp, me.added_time, me.updated_time,
me.filesize, me.disc, me.remote, me.audio, me.audio_size, me.audio_offset,
me.year, me.secs, me.cover, me.cover_cached, 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.dlna_profile,
me.musicbrainz_id, me.lossless, me.lyrics, me.replay_gain, me.replay_peak,
me.extid, me.virtual, me.coverid FROM tracks me LEFT JOIN genre_track
genreTracks ON genreTracks.track = me.id WHERE ( ( genre NOT IN ( SELECT me.id
FROM genres me WHERE ( ( me.namesearch LIKE ? OR me.namesearch LIKE ? ) ) ) AND
me.audio = ? ) ) GROUP BY me.id ORDER BY me.disc, me.titlesort COLLATE en_US
LIMIT 50: '%ROCK%', '%JAZZ%', '1'
--------------------
Does that shed any light on the situation? I said two years ago that I
intended to learn something about sql, but now I can demonstrate that it
hasn't happened.
As you certainly know, there is MUCH more in the log that I can provide,
if it would help.
LMS 8 nightly; 3 Squeezelite players connected by powerline ethernet; 5
wireless players connected via Airplay Bridge; 1 SqueezeAmp player
no high-end or esoteric audio gear
1 Squeezebox Radio (upgraded UE Smart Radio) now mostly retired
------------------------------------------------------------------------
RobbH's Profile: http://forums.slimdevices.com/member.php?userid=67008
View this thread: http://forums.slimdevices.com/showthread.php?t=112872
_______________________________________________
Squeezecenter mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
