Re: subquery vs. join?

[hector vass]

You might be able to phrase an easier question.

create temporary table t
select SQL_BIG_RESULT
login_ip,
count(*) as freq
from log
group by login_ip;

select
speed_type,
sum(freq) as freq
from t a , ip_region b
where a.login_ip between b.start_ip and b.end_ip
group by speed_type;