To me, that above query, with the forking joins, shows why the result set is so huge (i.e. MILLIONS of rows that mysqld has to consolidate via "group by".
Now, here's a variation (dropping the join to contributorAlbums) on that query that returns the same data as does the web interface, and does it in a fraction of a second: +-------------------------------------------------------------------+ |Filename: qBadQueryPicA.jpg | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=4967| +-------------------------------------------------------------------+ -- 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
