I think what needs to happen here is that someone needs to check if the queries that gharris reports are actually those used by the SBC.
If that's the case, then it doesn't really matter if some people don't see the issue. There is an incorrect join producing a cartesian product in the resultset. Any query that is returning 4 million records in a database with 40,000 tracks is obviously incorrect. Whether performance is acceptable or not, the results are likely to be incorrect. And as stated gharris is getting 43 artists back when 37 is the correct figure. This is why I never use embedded SQL if at all possible and make extensive use of stored procedures. -- oreillymj ------------------------------------------------------------------------ oreillymj's Profile: http://forums.slimdevices.com/member.php?userid=699 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
