Get the latest Laravel/PHP jobs, events and curated articles straight to your inbox, once a week
Source: dev.to
How to find the slowest query in your application
does it take ages to load? Are the users complaining that it's almost unusable?.
Of course, your website might be slow for a lot of reasons, but one of the most common reasons is slow database queries.
Fortunately, in laravel, we can define a callback that gets called every time a query gets executed (see https://laravel.com/docs/8.x/database#listening-for-query-events).
And the best part is that the first item in the collection is the exact place where we triggered the SQL query.
Of course, your website might be slow for a lot of reasons, but one of the most common reasons is slow database queries.
Fortunately, in laravel, we can define a callback that gets called every time a query gets executed (see https://laravel.com/docs/8.x/database#listening-for-query-events).
And the best part is that the first item in the collection is the exact place where we triggered the SQL query.
Newsletter
ToastMail
Achieve superior email deliverability with ToastMail! Our AI-driven tool warms up inboxes, monitors reputation, and ensures emails reach their intended destination. Sign up today for a spam-free future.
Community Partners
Laravel/PHP Careers