Ok, so having run:
Code:
--------------------
sudo -u squeezeboxserver /usr/bin/perl
/usr/share/squeezeboxserver_trunk/server/slimserver.pl --prefsdir
/var/lib/squeezeboxserver_trunk/prefs --logdir /var/log/squeezeboxserver_trunk/
--cachedir /var/lib/squeezeboxserver_trunk/cache --charset=utf8 --perfwarn
dbaccess=0.05
--------------------
..here is the result:
Code:
--------------------
[11-04-17 12:54:16.0303] Logging DB Access > 0.05000s
[11-04-17 12:54:32.9399] DB Access 0.17545 : SELECT COUNT( * ) FROM
(SELECT me.id FROM tracks me WHERE ( me.audio = ? ) GROUP BY me.id) count_subq:
'1'
[11-04-17 12:54:36.4561] DB Access 3.51130 : SELECT COUNT( * ) FROM
(SELECT me.id FROM albums me GROUP BY me.id) count_subq:
[11-04-17 12:54:38.6636] DB Access 2.20112 : SELECT COUNT( * ) FROM
(SELECT me.id FROM contributors me LEFT JOIN contributor_album
contributorAlbums ON contributorAlbums.contributor = me.id LEFT JOIN albums
album ON album.id = contributorAlbums.album WHERE ( ( ( album.compilation IS
NULL OR album.compilation = ? ) AND contributorAlbums.role IN ( ?, ? ) ) )
GROUP BY me.id) count_subq: '0', '1', '5'
[11-04-17 12:54:39.5436] DB Access 0.26909 : SELECT COUNT( * ) FROM albums
me:
[11-04-17 12:54:39.6029] DB Access 0.05347 : SELECT COUNT( * ) FROM
(SELECT me.id FROM contributors me LEFT JOIN contributor_album
contributorAlbums ON contributorAlbums.contributor = me.id LEFT JOIN albums
album ON album.id = contributorAlbums.album WHERE ( ( ( album.compilation IS
NULL OR album.compilation = ? ) AND contributorAlbums.role IN ( ?, ? ) ) )
GROUP BY me.id) count_subq: '0', '1', '5'
[11-04-17 12:54:39.7857] DB Access 0.12958 : SELECT COUNT( * ) FROM
(SELECT me.id FROM tracks me WHERE ( me.audio = ? ) GROUP BY me.id) count_subq:
'1'
[11-04-17 12:54:47.6654] DB Access 3.39466 : SELECT COUNT( * ) FROM
(SELECT me.id FROM albums me LEFT JOIN tracks tracks ON tracks.album = me.id
GROUP BY me.id) count_subq:
[11-04-17 12:54:47.7323] DB Access 0.06275 : SELECT COUNT( * ) FROM
(SELECT me.id FROM albums me LEFT JOIN tracks tracks ON tracks.album = me.id
GROUP BY me.id) count_subq:
[11-04-17 12:55:34.1512] DB Access 46.41464 : 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 LEFT JOIN tracks tracks ON
tracks.album = me.id GROUP BY me.id ORDER BY tracks.timestamp desc,
tracks.disc, tracks.tracknum, tracks.titlesort COLLATE en_US LIMIT 100:
[11-04-17 12:55:35.0545] DB Access 0.10799 : SELECT COUNT( * ) FROM
(SELECT me.id FROM tracks me WHERE ( me.audio = ? ) GROUP BY me.id) count_subq:
'1'
[11-04-17 12:55:39.9277] DB Access 0.06552 : SELECT COUNT( * ) FROM
(SELECT me.id FROM albums me LEFT JOIN tracks tracks ON tracks.album = me.id
GROUP BY me.id) count_subq:
[11-04-17 12:55:39.9943] DB Access 0.06242 : SELECT COUNT( * ) FROM
(SELECT me.id FROM albums me LEFT JOIN tracks tracks ON tracks.album = me.id
GROUP BY me.id) count_subq:
[11-04-17 12:55:40.6088] DB Access 0.61123 : 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 LEFT JOIN tracks tracks ON
tracks.album = me.id GROUP BY me.id ORDER BY tracks.timestamp desc,
tracks.disc, tracks.tracknum, tracks.titlesort COLLATE en_US LIMIT 100:
[11-04-17 12:55:41.2990] DB Access 0.10872 : SELECT COUNT( * ) FROM
(SELECT me.id FROM tracks me WHERE ( me.audio = ? ) GROUP BY me.id) count_subq:
'1'
--------------------
You can see where the simple webUI initiated My Muisic -> New Music
query has taken 46+ seconds to execute. After refreshing the web
browser to SBS home, the next My Muisc -> New Music is much more
reasonable..
Code:
--------------------
[11-04-17 14:20:43.4218] DB Access 0.50762 : 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 LEFT JOIN tracks tracks ON
tracks.album = me.id GROUP BY me.id ORDER BY tracks.timestamp desc,
tracks.disc, tracks.tracknum, tracks.titlesort COLLATE en_US LIMIT 100:
--------------------
..at 0.5 seconds.
--
gharris999
------------------------------------------------------------------------
gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115
View this thread: http://forums.slimdevices.com/showthread.php?t=87070
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
