mattur - 5:26 pm on Mar 29, 2009 (gmt 0)
Break it down into smaller queries eg by date or by ID number. Use this series of queries to populate another table, eg ProdID, OtherProdID, Score. Use this new table to pull the info for the product pages. Run a batch update overnight to keep the summary table up to date.