select stuff from pending_downloads left outer join a ton of stuff; no wait...
select host,COUNT(*) from pending_downloads etc... group by host order by requested then add the hosts to a may I use host plz request, then send the request. Then get a reply with NxM hosts I can use. and THEN select stuff from pending_downloads left outer join a ton of stuff except only those hosts somehow wait shit; uhh...
create temporary table those_hosts_somehow (derphost TEXT); insert into those_hosts_somehow etc...; and THEN
select stuff from pending_downloads INNER JOIN those_hosts_somehow ON derphost = host left outer join a ton of stuff
how is this so complicated... I just want to download stuff from a bunch of hosts, and not do more than like 3 downloads per host at a time. #fml
Add comment