Get the latest Laravel/PHP jobs, events and curated articles straight to your inbox, once a week
Source: sebrave.medium.com
PostgreSQL performance for Laravel applicationsCategory: Laravel, PHP
When you run an SQL query the database uses a number of techniques in order to optimise your query and return the results as quickly as possible. In this article we will run some experiments to get a better understanding of how to improve performance.
In just a couple of minutes we have seeded our table with a million rows.
The database had to read through every row of our table in order to return the data.
If we need to display a lot of data we can paginate the results in the UI.
In just a couple of minutes we have seeded our table with a million rows.
The database had to read through every row of our table in order to return the data.
If we need to display a lot of data we can paginate the results in the UI.
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