My SQL Indexieren

CREATE TABLE IF NOT EXISTS `technology` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Title` char(250) CHARACTER SET utf8 NOT NULL,
  `URL` char(250) CHARACTER SET latin1 NOT NULL,
  `description` text CHARACTER SET utf8 NOT NULL,
  `extra` text CHARACTER SET latin1 NOT NULL,
  `date` datetime NOT NULL,
  `Points` bigint(20) NOT NULL,
  `userdescription` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `htmlcode` longtext COLLATE utf8_unicode_ci NOT NULL,
  `IndexTimeTitle` timestamp NULL DEFAULT NULL,
  `IndexTimeHtmlCode` timestamp NULL DEFAULT NULL,
  `IndexTimeExtras` timestamp NULL DEFAULT NULL,
  `IndexTimeDescription` timestamp NULL DEFAULT NULL,
  `IndexTimeUserDescription` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1401016 


CREATE TABLE IF NOT EXISTS `search_word` (
  `pk` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `search_word` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`pk`),
  UNIQUE KEY `un_sw_word` (`search_word`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=24469 ;


CREATE TABLE IF NOT EXISTS `crosstabelle_description` (
  `PK` int(11) NOT NULL AUTO_INCREMENT,
  `FKSearchWord` int(11) NOT NULL,
  `FKSource` int(11) NOT NULL,
  `sourceTable` varchar(200) NOT NULL,
  `postionInText` int(11) NOT NULL,
  `frequencyInText` int(11) DEFAULT '1',
  PRIMARY KEY (`PK`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=571710 ;

	<?php
include("/include/daten_inc.php");
include("/include/connect_inc.php");
@ini_set("memory_limit", '6500M');

$datensatz = is_numeric($_GET["datensatz"]) ? $_GET["datensatz"] : 0;
$max       = 139403;



$sourcedatabase = '**************';
$sourceTable    = 'technology';
$sourceColounm  = 'description';

$tagetdatabase = '***************';
$targetTable   = 'crosstabelle_description';


$select = "SELECT ID FROM `tablenames`  WHERE `TableName` = '$sourceTable'";

mysql_select_db($tagetdatabase, $con);

$result        = mysql_query($select, $con);
$idSourceTable = mysql_fetch_row($result);

if ($idSourceTable[0] == null) {
    mysql_select_db($tagetdatabase, $con);
    
    
    $insert = "insert into `" . $tagetdatabase . "`.`tablenames` SET `TableName` = '" . $sourceTable . "',`ID` = NULL";
    //echo $insert;
    mysql_query($insert);
    $select = "SELECT ID FROM `tablenames`  WHERE `TableName` = '$sourceTable'";
    
    mysql_select_db($tagetdatabase, $con);
    
    $result        = mysql_query($select, $con);
    $idSourceTable = mysql_fetch_row($result);
    echo "<h1>";
    echo $idSourceTable[0];
    echo "</h1>";
    
}




$wordIndextargetTable = 'search_word';
$locSearch[]          = "=Ã?=i";
$locSearch[]          = "=ä|�=i";
$locSearch[]          = "=ö|�=i";
$locSearch[]          = "=ü|�=i";
$locSearch[]          = "=á|à |â|�|�|�=i";
$locSearch[]          = "=ó|ò|ô|�|�|�=i";
$locSearch[]          = "=ú|ù|û|�|�|�=i";
$locSearch[]          = "=é|è|ê|�|�|�|ë=i";
$locSearch[]          = "=Ã*|ì|î|Ã?|Ã?|Ã?|ï=i";
$locSearch[]          = "=ñ=i";
$locSearch[]          = "=ç=i";
$locSearch[]          = "=([0-9/.,+-]*\s)=";
$locSearch[]          = "=([^A-Za-z])=";
$locSearch[]          = "= +=";

$locReplace[] = "ss";
$locReplace[] = "ae";
$locReplace[] = "oe";
$locReplace[] = "ue";
$locReplace[] = "a";
$locReplace[] = "o";
$locReplace[] = "u";
$locReplace[] = "e";
$locReplace[] = "i";
$locReplace[] = "n";
$locReplace[] = "c";
$locReplace[] = " ";
$locReplace[] = " ";
$locReplace[] = " ";




// in $inStopwords ist ein numerisch indiziertes Array mit allen Stoppworten

$stopwords["onestopword"][] = "about";
$stopwords["onestopword"][] = "above";

// ALLE STOP Wörter


$stopwords["onestopword"][] = "zwischst";


$locSearch[] = "=(\s[A-Za-z]{1,2})\s=";
$locSearch[] = "= " . implode(" | ", $stopwords['onestopword']) . " =i";
$locSearch[] = "= +=";

$locReplace[] = " ";
$locReplace[] = " ";
$locReplace[] = " ";


if ($datensatz < $max) {
    $datensatz++;
    $select = "SELECT ID," . $sourceColounm . " FROM `" . $sourcedatabase . "`.`" . $sourceTable . "` WHERE `ID` = " . $datensatz;
    //echo $select;
    
    mysql_select_db($tagetdatabase, $con);
    
    $result      = mysql_query($select, $con);
    $resultarray = mysql_fetch_array($result);
    //echo $resultarray[$sourceColounm];
    $ID          = $resultarray['ID'];
    //echo $ID;
    $arrayvalue  = $resultarray[$sourceColounm];
    //echo $testi;
    
    
    
    
    
    $outString = trim(strtolower(stripslashes(strip_tags($resultarray[$sourceColounm]))));
    $inString  = preg_replace($locSearch, $locReplace, $outString);
    
    $outString = " " . str_replace(" ", "  ", $inString) . " ";
    $outString = trim(preg_replace($locSearch, $locReplace, $outString));
    
    
    
    $inWords = preg_split("/[\s,]+/", $outString);
    //print_r($inWords);
    
    
    $locData = array();
    
    foreach ($inWords as $locKey => $locVal) {
        
        
        
        if (strlen($locVal) > 32) {
            $locVal = substr($locVal, 0, 32);
        }
        
        
        $select = "SELECT pk FROM `search_word`  WHERE `search_word` = '$locVal'";
        
        mysql_select_db($tagetdatabase, $con);
        
        $result = mysql_query($select, $con);
        $result = mysql_fetch_row($result);
        //echo"<hr>";
        //echo $result[0];
        //echo"<hr>";
        
        if ($result[0] == null) {
            
            
            
            
            //echo "Insert";
            //echo"<hr>";
            //echo "<br>";
            $insert = "insert into `" . $tagetdatabase . "`.`search_word` SET `search_word` = '" . $locVal . "',`PK` = NULL";
            //echo $insert;
            mysql_query($insert);
            $select = "SELECT pk FROM `search_word`  WHERE `search_word` = '$locVal'";
            
            mysql_select_db($tagetdatabase, $con);
            
            $result = mysql_query($select, $con);
            $result = mysql_fetch_row($result);
            //echo"<hr>";
            //echo $result[0];
            //echo"<hr>";
            
            $insert = "insert into `" . $tagetdatabase . "`.`" . $targetTable . "` SET `FKSource` = '" . $ID . "',`FKSearchWord` = '" . $result[0] . "',`sourceTable` = '" . $idSourceTable[0] . "',`pk` = NULL";
            //echo $insert;
            mysql_query($insert);
            
            
        } else {
            //echo"<hr>";
            //echo"warh drinne";
            $select = "SELECT pk FROM `search_word`  WHERE `search_word` = '$locVal'";
            
            mysql_select_db($tagetdatabase, $con);
            
            $result = mysql_query($select, $con);
            $pk2    = mysql_fetch_row($result);
            //echo $pk2[0];
            
            $select = "SELECT pk FROM `" . $targetTable . "`  WHERE `FKSearchWord` = '" . $pk2[0] . "' and `FKSource` = '" . $ID . "'";
            //echo $select;
            mysql_select_db($tagetdatabase, $con);
            
            $result = mysql_query($select, $con);
            $result = mysql_fetch_row($result);
            //echo $result[0];
            if ($result[0] == null) {
                //echo"Leeer";
                $insert = "insert into `" . $tagetdatabase . "`.`" . $targetTable . "` SET `FKSource` = '" . $ID . "',`FKSearchWord` = '" . $pk2[0] . "',`sourceTable` = '" . $idSourceTable[0] . "',`pk` = NULL";
                //echo $insert;
                mysql_query($insert);
                //echo"<hr>";
            } else {
                //echo"Drinne";
                $select = "SELECT frequencyInText FROM `" . $targetTable . "`  WHERE `FKSearchWord` = '" . $pk2[0] . "' and `FKSource` = '" . $ID . "'";
                //echo $select;
                mysql_select_db($tagetdatabase, $con);
                
                $result          = mysql_query($select, $con);
                $result          = mysql_fetch_row($result);
                //echo "<h1>";
                //echo $result[0];
                $frequencyInText = $result[0];
                //echo "</h1>";
                
                
                $update = "update `" . $targetTable . "`set `frequencyInText` ='" . $frequencyInText = $frequencyInText + 1 . "' WHERE `FKSearchWord` = '" . $pk2[0] . "' and `FKSource` = '" . $ID . "'";
                //echo     $update ;
                mysql_query($update);
                
                // hier account
                //echo"<hr>";
            }
              
            
            
            
        }
        
        
        
    }
    $timestamp = date("Y-m-d  H:i:s", time());
    $insert    = "UPDATE `" . $sourcedatabase . "`.`" . $sourceTable . "` SET `IndexTimeDescription` = '" . $timestamp . "' where ID =" . $ID;
    ////echo $insert;
    mysql_query($insert);
    
?>
         <script type="text/javascript">
            window.onload = function() {
            
              window.document.location.href = '<?php
    echo $_SERVER["PHP_SELF"];
?>?datensatz=<?php
    echo $datensatz;
?>';
            }
          </script>
  <?php
}
echo $datensatz;


?>

$insert = "insert into `" . $tagetdatabase . "`.`search_word` SET `search_word` = '" . $locVal . "',`PK` = NULL";
//echo $insert;
mysql_query($insert);
$select = "SELECT pk FROM `search_word`  WHERE `search_word` = '$locVal'";

$result = mysql_query($select, $con);
$result = mysql_fetch_row($result);