Re: speed up query

[laptop alias]

I'm not too hot at this stuff, but as a start I'd be tempted to throw an index onto site.dslam_region and see where that gets you.

Also, please format your queries for human readability, e.g.:

SELECT AVG(snrup)   	snrup
     , AVG(snrdown) 	snrdown
     , sip.id		id
     , s.dslam_region	dslam_region
  FROM dsl_data		dd
  JOIN dslam_ports 	dp
    ON dp.id = dd.port_id
  JOIN site_ip		sip
    ON sip.id = dp.dslam_id
  JOIN site         	s 
    ON s.id = sip.did
 WHERE s.dslam_region='itr'
   AND dd.time BETWEEN '2010-01-01' AND '2010-02-01' 
 GROUP 
    BY s.id 
 ORDER 
    BY snrdown DESC;