Triode;295971 Wrote:
> It would probably be useful to run the server with --perfwarn=0.5 and
> add the results to the bug. (Need to start the server from the command
> line)
>
> --perfwarn dbaccess=0.1
>
> would just give the queries which are slow as measured by the server
Triode: I can't get either of those args to produce any output in the
server log. However, when I go to SC
Settings->Advanced->Logging->(database.sql) and set it to debug, I do
get the following:
Using the web UI, browsing Genre->German Baroque, the query triggered
to get the artist count is:
Code:
--------------------
[08-04-28 09:00:14.0803] Slim::Schema::Debug::query_start (26) SELECT COUNT(
DISTINCT( contributor.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 ) WHERE ( ( ( ( (
contributorTracks.role IN ( ?, ? ) ) AND ( me.id = ? ) ) ) ) ): '1', '5', '7'
--------------------
This query, when executed in MySQL query browser, returns "37" in a
fraction of a second.
Using the SBC, attempting a Music Library->Genres->German Baroque, the
query logged is:
Code:
--------------------
[08-04-28 09:01:40.8084] Slim::Schema::Debug::query_start (26) SELECT COUNT(
DISTINCT( me.id ) ) FROM contributors me LEFT JOIN contributor_track
contributorTracks ON ( contributorTracks.contributor = me.id ) JOIN tracks
track ON ( track.id = contributorTracks.track ) LEFT JOIN genre_track
genreTracks ON ( genreTracks.track = track.id ) LEFT JOIN contributor_album
contributorAlbums ON ( contributorAlbums.contributor = me.id ) WHERE ( ( (
genreTracks.genre = ? ) AND ( contributorAlbums.role IN ( ?, ? ) ) ) ): '7',
'1', '5'
--------------------
That query returns "43" and takes 38 seconds to execute.
Again, the SBC times out in the middle of the query and looses
connection to SC.
Notice the difference in those two queries. The SBC is using a
different query to get the artist count. It's a mal-formed query.
THIS IS A BUG.
--
gharris999
------------------------------------------------------------------------
gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115
View this thread: http://forums.slimdevices.com/showthread.php?t=46850
_______________________________________________
jive mailing list
[email protected]
http://lists.slimdevices.com/cgi-bin/mailman/listinfo/jive
