Efficient Pagination Using Deferred Joins
– aaronfrancis.com - submitted by Aaron Francis
A slight modification to traditional offset/limit pagination that can drastically boost performance.
Read more [aaronfrancis.com]
Posts tagged with performance
Streaming HTTP response in PHP - turn long-running process into realtime UI
– itsrav.dev - submitted by Sourav R
Output Buffering is not so popular these days, but it is powerful. with simple vintage OB technique I made a real-time payment process UI
Read more [itsrav.dev]
Join thousands of developers
Every two weeks, I share practical tips, tutorials, and behind-the-scenes insights from maintaining 300+ open source packages.
No spam. Unsubscribe anytime. You can also follow me on X.
Filtering Carbon Period For Flexibility And Performance
Here's a nice way to go about filtering Carbon instances
Read more [tomerbe.co.uk]
Swoole vs Roadrunner for Laravel Octane
– chriswhite.is - submitted by Chris White
Choosing between Swoole and Roadrunner in a Laravel Octane deployment can be overwhelming - in this post I compare the advantages and disadvantages of both.
Read more [chriswhite.is]
Increase Database Performance By Using Multiple Columns
By thinking outside of the box, you can often get much faster database performance by splitting values across multiple database columns.
Read more [downing.tech]
Efficient Distance Querying in MySQL
– aaronfrancis.com - submitted by Aaron Francis
A clever use of MySQL indexes and generated columns to make blazing fast geolocation searches.
Read more [aaronfrancis.com]
How to update large data in Laravel
Here are a few best practices for working with a large tables.
Read more [42coders.com]
Introducing lazy loading prevention into an existing application
– timacdonald.me - submitted by Tim Mac
Introduce lazy loading to an existing application without interrupting flow or overwhelming your logs
Read more [timacdonald.me]
Strategies for decreasing the number of queries in a Laravel app
Oh Dear is all-in-one solution to monitor your site that my buddy Mattias Geniar and I have created. It can monitoring uptime, certificates, broken links, scheduled jobs, and much more.
Under the hood, Oh Dear is a large Laravel application that performs many queries all of the time. To power future features, we've recently changed our database structure and refactored some pieces in our code base. We increased performance by decreasing the number of queries.
In this blog post, we'd like to to share some techniques that might be helpfull to increase the performance of your Laravel app too.
Generators vs arrays
– doeken.org - submitted by Doeke Norg
Yield better results by iterating over generators. Learn more about these supercharged arrays that can preserve memory.
Read more [doeken.org]
Introducing Laravel Google Fonts
Sebastian made a pretty interesting package to self host Google Fonts
Read more [sebastiandedeyne.com]
Runtime (Big O) Of Laravel's One-Of-Many Relationship
In this article Lennart Carstens-Behrens explains a very impressive PR he recently submitted at the Laravel repo.
Read more [lennartcb.me]
Optimizing Vue for Speed, Performance, and Core Web Vitals
Matt Stauffer on how to minimize Vue's impact on the Core Web Vitals?
Read more [mattstauffer.com]
Dealing with the n+1 problem in Laravel
Mohamed shows how you can deal with N+1 problems using the $with model attribute and the newly added Model::preventLazyLoading() method.
Performance problems caused by array_unique
Benjamin Eberlei tells the story of a performance mistake that is quickly made even by experienced developers.
Read more [tideways.com]
How to optimize ORDER BY RANDOM()
Tobias explains how you can make this operation very fast even if your table has several million records.
Read more [tpetry.me]
Offset vs Cursor Pagination in Laravel
– www.laravel-enlightn.com - submitted by Paras Malhotra
An in-depth guide on offset and cursor pagination in Laravel, and the pros and cons of each.
Read more [www.laravel-enlightn.com]
A lightweight solution for running PHP code concurrently
Our team released a new package called spatie/fork. Using this package you can easily execute multiple pieces of code concurrently.
Function Inlining in PHP's Zend Engine
PHP has several over 30 functions at the moment that make use of special OPCodes or otherwise inlined to improve performance.
Read more [php.watch]
Laravel Worldwide Meetup #8: Using Vite in Laravel & How to optimize your DB indexes
Here's the recording of Laravel Wordwide Meetup #8. My guests for this edition were Kai Sassnowski talking on the importance of DB indexes, and Sebastian De Deyne on how to use Vite in Laravel.