Sebastian wrote:
this query runs slow because AVG and COUNT on maps_rating table i think. can anything be done to improve?
You may want to include: - table definitions (output of SHOW CREATE TABLE <table>) - output of EXPLAIN <query> This way the list members can make better suggestions. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
