how to creat above 1 million key words list ?

CREATE TABLE IF NOT EXISTS `worte` (
  `id` int(99) NOT NULL AUTO_INCREMENT,
  `keywort` varchar(300) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,
  `sematic` varchar(1000) NOT NULL,
  `benutzt` int(1) NOT NULL,
  `cache` int(5) NOT NULL,
  `ger_search` varchar(20) NOT NULL,
  `global_search` varchar(20) NOT NULL,
  `cpc` varchar(7) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13876 ;

<?php
include('start.php');

$null="0";
$abfrage = "Select * FROM worte where benutzt!='1' ORDER BY RAND() LIMIT 30";
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_object($ergebnis))
{$key=$row->keywort;
$key=utf8_encode($key);
$r_url="http://www.semager.de/api/keyword.php?q=".$key."&lang=en&out=html&count=&threshold=";
$r_file = file_get_contents("$r_url");

 
//sonderzeichen umwandeln
$r_file=utf8_decode($r_file);


preg_match_all('~<span style="font-size:(.*)%;">(.*)</span>  ~U', $r_file, $new);
unset($new[0]);

//neue worte einspeichern
$anzahl_neu=count($new[1]);
$a=0;
while($a<$anzahl_neu)
{
$new_key=$new[2][$a];
$new_cache=$new[1][$a];
//schauen ob schon da
  $kg="Select * FROM worte WHERE keywort='$new_key' LIMIT 1";
  $er = mysql_query($kg);
  while($ruw = mysql_fetch_object($er))
  { $id=$ruw->id;}
  if($id=="")
  {
  mysql_query("INSERT INTO worte
  (keywort,cache) VALUES ('$new_key','$new_cache')");
  }
  else
  {$aendern = "UPDATE worte Set cache='$new[1][$a]' WHERE id='$id'";
  $update = mysql_query($aendern);
  }
  $a++;
  $id="";
}
$a=0;

//sematic einschreiben
  $kg="Select * FROM worte where cache>'0' ORDER BY cache";
  $er = mysql_query($kg);
  while($ruw = mysql_fetch_object($er))
{$sematic=$sematic."|".$ruw->id."|";}
echo "<p>".$key." ->".$sematic."</p>";
$aendern = "UPDATE worte Set sematic='$sematic' WHERE keywort='$key'";
$update = mysql_query($aendern);

//cache leeren
$aendern = "UPDATE worte Set cache='0'";
$update = mysql_query($aendern);

//benutzt einschreiben
$aendern = "UPDATE worte Set benutzt='1' WHERE keywort='$key' LIMIT 1";
$update = mysql_query($aendern);

$sematic="";
}


echo "<meta http-equiv=\"refresh\" content=\"0; URL=http://localhost/search/scrape_key.php\">";
?>