問題描述

我想從數(shù)據(jù)庫中刪除大量項目(1M+)，我分叉了一個后臺作業(yè)來處理這個問題，這樣用戶就不必等待它完成繼續(xù)無論他/她在做什么，問題是，當項目被刪除時，應用程序變得沒有響應，所以我想我會一個塊一個塊地處理這些項目，然后休眠幾秒鐘，然后繼續(xù).

I have a large number of items (1M+) that i want to delete from a database, i fork a background job to take care of that, so that the user won't have to wait for it to finish to carry on whatever he/she was doing, the problem is, the app becomes unresponsive while the items are being deleted, so i thought that i would process the items chunk by chunk and sleep for a couple of seconds then carry on.

這是處理刪除的代碼:

// laravel job class
// ...
public function handle()
{
    $posts_archive = PostArchive::find(1); // just for the purpose of testing ;)
    Post::where('arch_id', $posts_archive->id)->chunk(1000, function ($posts) {
        //go through the collection and delete every post.
        foreach($posts as $post) {
            $post->delete();
        }
        // throttle
        sleep(2);
    });
}

預期結(jié)果:帖子被分塊并處理每個塊，然后空閑 2 秒，重復此操作，直到所有項目都被刪除.

Expected result: the posts are chunked and each chunk is processed, then idle for 2 seconds, repeat that until all the items are deleted.

實際結(jié)果:隨機刪除一次，過程結(jié)束.沒有錯誤沒有指標，沒有線索?

Actual result: a random number of items is deleted once, then the process ends. no errors no indicators, no clue ?

有沒有更好的方法來實現(xiàn)這一點?

is there a better way to implement this?

推薦答案

Laravel 并沒有針對您處理此問題的方式進行具體說明.如果作業(yè)中的刪除查詢凍結(jié)了 UI 的其余部分，聽起來您的數(shù)據(jù)庫服務器需要審查或優(yōu)化.

There is nothing Laravel specific about the way you'd handle this. It sounds like your database server needs review or optimization if a delete query in a job is freezing the rest of the UI.

檢索每個模型并單獨運行刪除查詢絕對不是優(yōu)化此操作的好方法，因為您將執(zhí)行數(shù)百萬個查詢.如果您希望嘗試限制應用程序中的每秒負載而不是優(yōu)化數(shù)據(jù)庫服務器來處理此查詢，則可以使用帶有刪除限制的 while 循環(huán):

Retrieving each model and running a delete query individually definitely isn't a good way to optimize this as you'd be executing millions of queries. You could use a while loop with a delete limit if you wish to try to limit the load per second in your application instead of optimizing your database server to handle this query:

do {
    $deleted = Post::where('arch_id', $posts_archive->id)->limit(1000)->delete();
    sleep(2);
} while ($deleted > 0);

這篇關于Laravel 塊和刪除的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！