首頁猿問 php sql...

php sql update追加更新大量數(shù)據(jù)超時無響應(yīng) 怎么解決

PHP

犯罪嫌疑人X 2019-03-10 12:06:19

UPDATE `addon` SET `productsimages`= concat(productsimages,'##','BD-PT4878-1.jpg'),`jieshao`=concat(jieshao,'##','Immunohistochemical analysis of paraffin-embedded human-stomach-cancer tissue. 1,VIM PolBD-PClonal Antibody was diluted at 1:200(4°,overnight). 2, Sodium citrate pH 6.0 was used for antigen retrieval(>98°C,20min). 3,Secondary antibody was diluted at 1:200（room temperature, 30min) Negtive control was used by secondary antibody only.)') WHERE typeid='190' AND catalogno='BD-PT4878'; catalogno不是索引執(zhí)行如上語句，一共1W多條，無響應(yīng)，分兩次，一次5000條也還是無響應(yīng)，試過組合數(shù)組，然后foreach執(zhí)行，無響應(yīng)。該怎么辦呢 - -

查看完整描述

4 回答

滄海一幻覺

TA貢獻(xiàn)1824條經(jīng)驗獲得超5個贊

這個好解決，還是索引效率的問題。

UPDATE `addon` SET `productsimages`= concat(productsimages,'##','BD-PT4878-1.jpg'),`jieshao`=concat(jieshao,'##','Immunohistochemical analysis of paraffin-embedded human-stomach-cancer tissue. 1,VIM PolBD-PClonal Antibody was diluted at 1:200(4°,overnight). 2, Sodium citrate pH 6.0 was used for antigen retrieval(>98°C,20min). 3,Secondary antibody was diluted at 1:200（room temperature, 30min) Negtive control was used by secondary antibody only.)') WHERE id in (select id from addon where typeid='190' AND catalogno='BD-PT4878');

反對回復(fù) 2019-03-18

慕尼黑8549860

TA貢獻(xiàn)1818條經(jīng)驗獲得超11個贊

大量更新業(yè)務(wù)操作是在一定情況下偶發(fā)還是經(jīng)常操作的

如果是偶發(fā)建議停業(yè)務(wù)操作

如果是經(jīng)常操作考慮業(yè)務(wù)上是否可以做及時處理或分發(fā)消息異步處理

上面的直接操作沒有時間限定，你可以起一個進(jìn)程，每隔一定時間處理一定的數(shù)量，比如1分鐘處理100個更新，然后sleep(10)迭代處理，

偽代碼

$limit = 0;
$offset = 100;
while(true) {
    $data = getLists($limit);
    // operate
    doit($data);
    sleep(10);
    // log
    $limit += $offset;
}

反對回復(fù) 2019-03-18