As MYSQL keeps dying on me, is there any way to make the following query less resource intensive?
//retrieve those userids that have a corresponding entry in the ufJoin table
$query = "SELECT users.userid AS userid, users.email AS email, users.format AS format
FROM users, ufJoin
WHERE users.userid=ufJoin.userid
AND users.val='1'
GROUP BY users.userid";
$result = safe_query($query);
// deal with each user separately
while($x=mysql_fetch_assoc($result)) {
//retrieve those urls that correspond to this userid
$url_query = "SELECT feeds.url AS url, ufJoin.items AS items
FROM feeds, ufJoin
WHERE ufJoin.feedid=feeds.feedid
AND ufJoin.freq='1'
AND ufJoin.userid={$x['userid']}";
$go=safe_query($url_query);
if(!mysql_num_rows($go)=='0'){
while($ds=mysql_fetch_array($go)) {
