找到一个更快的功能然后“gethostbyname”？

Question

I run a script under xampp with a mysqlDB.

I check if a domainname has an ip.

The problem is, that I have to check over 100000 domain names from a MySQL_DB.

The function "gethostbyname" works great, but my solution is too slow.

while($row = mysqli_fetch_array($db_res)) { // get the DB domainnames entrys
    if (empty($row['status'])) {  
      $items[] =  $row['domainnames'];
    } 
    foreach ($items AS $domain) { 
        if ( gethostbyname($domain) != $domain ) {
            do somthing.....
        }
    }
}

How do I get it faster?

Answer 1

Looks like when your while loop iterates, it uses the $items from the last iteration - which will waste time - so please try this version (putting the foreach into the if:

while($row = mysqli_fetch_array($db_res)) { // get the DB domainnames entrys
  if (empty($row['status'])) {  
    $items[] =  $row['domainnames'];
    foreach ($items AS $domain) { 
      if ( gethostbyname($domain) != $domain ) {
        do somthing.....
      }
    }
  } 
}