Database query and error when executing in the production environment: 504 Timeout. | Laravel | Page 1

hot scroll May 30, 2024, 5:31 PM

#

How much data is in prod? most likely the query takes too long and nginx kills the process.

quick trout May 30, 2024, 5:52 PM

#

The table in question has a little more than 40 thousand rows...

hot scroll May 30, 2024, 5:53 PM

#

Then I guess that's the problem, the query is too expensive and either should look why regex is needed and maybe it could be written differently, maybe split into multiple queries or needs indexes.

#

I'd say you could do ddRawSql or dd the sql depending on laravel version and run the raw sql directly in database to see how long it takes, maybe explain analyze, but if it truly takes extremely long time it might not be advised on a production database.

#Database query and error when executing in the production environment: 504 Timeout.