Increase Database Performance By Using Multiple Columns
– downing.tech – Edit
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 – Edit
A clever use of MySQL indexes and generated columns to make blazing fast geolocation searches.
Read more [aaronfrancis.com]
Join 9,500+ smart developers
Get my monthly newsletter with what I learn from running Spatie, building Oh Dear, and maintaining 300+ open source packages. Practical takes on Laravel, PHP, and AI that you can actually use.
No spam. Unsubscribe anytime. You can also follow me on X.
"If you are one of the *millions* who have downloaded a Spatie package, then you understand the quality that Freek aims for. The newsletter is of the same quality of any Spatie package you're using."
How to update large data in Laravel
– 42coders.com – Edit
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 – Edit
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 original
by Freek Van der Herten – 13 minute read – Edit
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 – Edit
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
– lennartcb.me – Edit
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
– mattstauffer.com – Edit
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
– Edit
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
– tideways.com – Edit
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 – Edit
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 original
by Freek Van der Herten – 1 minute read – Edit
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 original
by Freek Van der Herten – 1 minute read – Edit
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.
Improving Google Maps Performance on Large Datasets
– tighten.co - submitted by Jamison Valenta – Edit
Here are some hot tips for mapping large datasets on Google Maps, without sacrificing performance.
Read more [tighten.co]
Maximizing response caching in Laravel
– samuelstancl.me – Edit
Response caching is like a progressive enhancement. It will make your app faster in some ways, and some cases, but your app must work perfectly well without it.
Read more [samuelstancl.me]
Fibers in PHP: A new opportunity for async PHP?
– clue.engineering – Edit
It looks like PHP will get fibers soon with PHP 8.1! That’s awesome! Or is it?
Read more [clue.engineering]
A JIT compiler for Tailwind CSS
– Edit
Incredible work by Adam Wathan and his team.
