大家好^^
我寫了一小段程式
要從電腦192.168.0.20資料庫rich88
中的table "person"
複製到
電腦192.168.1.30資料庫rich99
中的table "tperson"
最後寫入一個檔案"patient"
程式可以執行
可是我發現
cpu使用率高達50%
我弄不懂?.?
請大家幫幫忙
謝謝大家^^

<?php
   $STORE_ID='888';
   $conn=mysql_connect('192.168.0.20:3388','root','');
   if(!$conn)
   {
    die('Could not connect: '.mysql_error());
   }
   mysql_select_db('rich88');
   $query="SELECT * FROM person";
   $result=mysql_query($query);
   $new=mysql_numrows($result);
   if(!$result)
   {
    die('Query failed: ' . mysql_error());
   }
   $conn2=mysql_connect('192.168.1.30:3330','root','');
   if(!$conn2)
    {
     die('Could not connect: '.mysql_error());
    }
   mysql_select_db('rich99');
   $i=0;
   while($i<$new)
   {
    $ID=mysql_result($result,$i,"ID");
    $NAME=mysql_result($result,$i,"NAME");
    $BDAY=mysql_result($result,$i,"BDAY");
    $BNO=mysql_result($result,$i,"BNO");
    $TEL=mysql_result($result,$i,"TEL1");
    //寫入table tperson
    $bobo="REPLACE INTO tperson(STORE_ID,ID,NAME,BDAY,BNO,TEL1)
                          VALUES('$STORE_ID','$ID','$NAME','$BDAY','$BNO','$TEL')";
    if(!mysql_query($bobo))
       {
       die('Query failed: ' . mysql_error());
       }
    $ID2=STR_PAD(mysql_result($result,$i,"ID"),10,' ',STR_PAD_RIGHT);
    $NAME2=STR_PAD(mysql_result($result,$i,"NAME"),20,' ',STR_PAD_RIGHT);
    $BDAY2=STR_PAD(mysql_result($result,$i,"BDAY"),9,' ',STR_PAD_RIGHT);
    $BNO2=STR_PAD(mysql_result($result,$i,"BNO"),10,' ',STR_PAD_RIGHT);
    $TEL2=STR_PAD(mysql_result($result,$i,"TEL1"),16,' ',STR_PAD_RIGHT);
    //合併字串
    $aa="$STORE_ID"."        "."$ID2"."$NAME2"."$BDAY2"."$BNO2"."$TEL2";
      if(!$f=fopen("D:\patient","a+"))
      {
      echo "Cannot open file D:\patient";
      exit;
      }
    //寫入檔案
    fwrite($f,$aa);
    fclose($f);
    $i++;
   }
   mysql_free_result($result);
   mysql_close($conn);
   mysql_close($conn2);
?>