mamema wrote:
> which indexes do you mean? Except those from the temp table, we've
> discussed in the Dev Area, all needed indexes are there.
> Trackstat creates and deletes indexes and both is working.
see previous comment for the rationale. also:
Code:
--------------------
explain query plan UPDATE track_history SET url=(select tracks.url from
library.tracks where tracks.musicbrainz_id is not null and
tracks.musicbrainz_id=track_history.musicbrainz_id and
track_history.urlmd5!=tracks.urlmd5 and length(tracks.url)<512),urlmd5=(select
tracks.urlmd5 from tracks where tracks.musicbrainz_id is not null and
tracks.musicbrainz_id=track_history.musicbrainz_id and
track_history.urlmd5!=tracks.urlmd5 and length(tracks.url)<512) where exists
(select tracks.url from tracks where tracks.musicbrainz_id is not null and
tracks.musicbrainz_id=track_history.musicbrainz_id and track_history.urlmd5 !=
tracks.urlmd5 and length(tracks.url)<512);
--------------------
Code:
--------------------
SCAN TABLE track_history
CORRELATED SCALAR SUBQUERY 3
SEARCH TABLE tracks USING COVERING INDEX trackStatMBURLIndex
(musicbrainz_id=?)
CORRELATED SCALAR SUBQUERY 1
SEARCH TABLE tracks USING COVERING INDEX trackStatMBURLIndex
(musicbrainz_id=?)
CORRELATED SCALAR SUBQUERY 2
SEARCH TABLE tracks USING COVERING INDEX trackStatMBURLIndex
(musicbrainz_id=?)
--------------------
Code:
--------------------
explain query plan select library.tracks.url from
library.tracks,persist.track_history where library.tracks.musicbrainz_id is not
null and library.tracks.musicbrainz_id=track_history.musicbrainz_id and
persist.track_history.urlmd5 != library.tracks.urlmd5 and
length(library.tracks.url)<512;
--------------------
Code:
--------------------
SCAN TABLE track_history USING COVERING INDEX tsurlmdmbIndex
SEARCH TABLE tracks USING COVERING INDEX trackStatMBURLIndex
(musicbrainz_id=?)
--------------------
'Various SW' (https://www.nexus0.net/pub/sw/): Web Interface | TUI |
Playlist Editor / Generator | Music Classification | Similar Music |
Announce | EventTrigger | Chiptunes | LMSlib2go | ...
'Various HowTos' (https://www.nexus0.net/pub/documents/LMS/): build a
self-contained LMS | Bluetooth/ALSA | Control LMS with any device | ...
------------------------------------------------------------------------
Roland0's Profile: http://forums.slimdevices.com/member.php?userid=56808
View this thread: http://forums.slimdevices.com/showthread.php?t=114067
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
