Dan: I'm leaving for Europe tomorrow early and will be out of pocket
until the beginning of September. If you would like me to check
anything else this evening, I'll be happy to, if I can fit it in.
I don't know if this is relevant, but my library is all whole-album
flac files with embedded cuesheets.
I just wiped and rescanned my library a couple of hours ago. Here is
the latest slow query reading from the log:
Code:
--------------------
# Time: 060814 20:25:37
# [EMAIL PROTECTED]: slimserver[slimserver] @ localhost [127.0.0.1]
# Query_time: 51 Lock_time: 0 Rows_sent: 1 Rows_examined: 15397333
SELECT COUNT( DISTINCT( track_2.id ) ) FROM genres me LEFT JOIN genre_track
genreTracks ON ( genreTracks.genre = me.id ) JOIN tracks track ON ( track.id =
genreTracks.track ) LEFT JOIN contributor_track contributorTracks ON (
contributorTracks.track = track.id ) JOIN contributors contributor ON (
contributor.id = contributorTracks.contributor ) LEFT JOIN contributor_track
contributorTracks_2 ON ( contributorTracks_2.contributor = contributor.id )
JOIN tracks track_2 ON ( track_2.id = contributorTracks_2.track ) WHERE ( ( ( (
( contributorTracks.role IN ( '1', '5' ) ) AND ( me.id = '4' ) ) ) ) );
--------------------
Again, this query was triggered by trying to browse into the album
level by genre. For this genre, I've got 441 flac files in 27 folders
weighing in at 101 gigabytes.
--
gharris999
------------------------------------------------------------------------
gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115
View this thread: http://forums.slimdevices.com/showthread.php?t=26354
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/beta
