[請益] mysql_query(insert) 問題
$k=1;
for($i=0;$i<$total;$i++){
for($j=$k;$j<$total;$j++){
$and_rel = get_amount_of_data($send[$i], $send[$j], $AND);
$or_rel = get_amount_of_data($send[$i], $send[$j], $OR);
$rel_coff = 0;
if($or_rel != 0) {
$rel_coff = $and_rel/$or_rel;
if($rel_coff < 0.000001) $rel_coff = 0;
}
$sql="INSERT relation2(id_1,id_2,weight)
VALUES('{$send[$i]}','{$send[$j]}','$rel_coff')" ;
mysql_query($sql);
}
$k++;
}
我用兩個LOOP 把計算過後的某個值 rel_coff 存到TABLE中
總資料應該有4萬多筆
但是每次都跑到1870左右就卡住了
請問是有TABLE容量上限嗎
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.123.103.207
→
02/21 16:45, , 1F
02/21 16:45, 1F
→
02/21 17:21, , 2F
02/21 17:21, 2F
→
02/21 19:21, , 3F
02/21 19:21, 3F
→
02/21 19:21, , 4F
02/21 19:21, 4F
→
02/21 20:01, , 5F
02/21 20:01, 5F
→
02/21 21:22, , 6F
02/21 21:22, 6F
→
02/21 21:22, , 7F
02/21 21:22, 7F
→
02/21 21:22, , 8F
02/21 21:22, 8F
→
02/21 22:01, , 9F
02/21 22:01, 9F
→
02/21 22:35, , 10F
02/21 22:35, 10F
推
02/21 23:14, , 11F
02/21 23:14, 11F
→
02/21 23:15, , 12F
02/21 23:15, 12F
→
02/21 23:41, , 13F
02/21 23:41, 13F
→
02/21 23:41, , 14F
02/21 23:41, 14F
→
02/21 23:42, , 15F
02/21 23:42, 15F
→
02/22 07:25, , 16F
02/22 07:25, 16F
→
02/23 15:55, , 17F
02/23 15:55, 17F
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
