Trying to delete thousands of records in bulk gives 504 Gateway Timeout

[philsturgeon]

• Laravel Version: 10.25.1
• Nova Version: 4.27.13
• PHP Version: 8.2 (laravelphp/vapor:php82)
• Database Driver & Version: MySQL
• Operating System and Version: laravelphp/vapor:php82
• Browser type and version: Firefox 118.0.2 (64-bit)

Description:

I need to wipe out all the trees planted at a location, there's 27,000 of them, and when I try to delete them all I only get about 1000-4000 deleted before the bulk delete returns a 504, and the delete modal window does not show anythinig went wrong.

Detailed steps to reproduce the issue on a fresh Nova installation:

Create several thousand records. Something over 10,000. On the index view filter by something, then try to delete all.

This is hosted on vapor with timeout set to 30 seconds.

Here's a video.

Screen.Recording.2023-10-24.at.4.55.38.PM.mov

Perhaps the delete process needs to be able to batch or individually delete records to let the browser handle some of this load?

[philsturgeon]

@crynobone hey this was converted to a discussion, but I'm not sure what we're meant to be discussing?

Question: Should Laravel Nova be able to delete thousands of records when deployed on Laravel Vapor?

If yes, this is a problem with the way Nova has been built to handle large numbers of deletions.

If no, this option should be disabled.

I have not had a chance to benchmark the queries happening in the background, but I would not expect a DELETE ... WHERE id IN(...) to take so long. Is it reading models in via Eloquent find() or get() then doing a delete()?