Articles | Mohamed Said      [Skip to content](#main)  [ ![](https://cdn.msaied.com/01KT78WE565VEMM3PSNQAAB0MH.png) Mohamed SaidLaravel Backend Engineer ](https://msaied.com) - [Home](https://msaied.com)
- [Projects](https://msaied.com/projects)
- [Articles](https://msaied.com/articles)
- [Certificates](https://msaied.com/certificates)
- [About](https://msaied.com#about)

           [  Contact](https://msaied.com#contact) Menu 

Menu
----

Close 

 - [HomeStart here](https://msaied.com)
- [ProjectsCase studies](https://msaied.com/projects)
- [ArticlesEngineering notes](https://msaied.com/articles)
- [CertificatesCredentials](https://msaied.com/certificates)
- [AboutHow I work](https://msaied.com#about)
- [ContactGet in touch](https://msaied.com#contact)

  [Start a conversation](https://msaied.com#contact) [WhatsApp](https://wa.me/201094619204) [Email](mailto:hello@msaied.com) 

  1. [Home](https://msaied.com)
2. /
3. Articles

  Engineering library
====================

 5 articles by Mohamed Said on Laravel, PHP, databases, APIs and infrastructure, written from production work.

 Search articles ⌕×Search 

    Topic hubs
----------

←→

- [AI48 articles](https://msaied.com/articles?category=ai&search=optimization&sort=new)
- [Composer Pacakge81 articles](https://msaied.com/articles?category=composer-pacakge&search=optimization&sort=new)
- [Filament27 articles](https://msaied.com/articles?category=filament&search=optimization&sort=new)
- [Laravel267 articles](https://msaied.com/articles?category=laravel&search=optimization&sort=new)
- [Livewire13 articles](https://msaied.com/articles?category=livewire&search=optimization&sort=new)
- [Open Source44 articles](https://msaied.com/articles?category=open-source&search=optimization&sort=new)
- [PHP27 articles](https://msaied.com/articles?category=php&search=optimization&sort=new)
- [Tips &amp; Tricks32 articles](https://msaied.com/articles?category=tips-tricks&search=optimization&sort=new)

  Topics
------

 [All topics](https://msaied.com/articles?search=optimization&sort=new) [AI 48](https://msaied.com/articles?category=ai&search=optimization&sort=new) [Composer Pacakge 81](https://msaied.com/articles?category=composer-pacakge&search=optimization&sort=new) [Filament 27](https://msaied.com/articles?category=filament&search=optimization&sort=new) [Laravel 267](https://msaied.com/articles?category=laravel&search=optimization&sort=new) [Livewire 13](https://msaied.com/articles?category=livewire&search=optimization&sort=new) [Open Source 44](https://msaied.com/articles?category=open-source&search=optimization&sort=new) [PHP 27](https://msaied.com/articles?category=php&search=optimization&sort=new) [Tips &amp; Tricks 32](https://msaied.com/articles?category=tips-tricks&search=optimization&sort=new)    5 articles
-----------

Topics    Sort articles Newest first  Oldest first  Sort  

 [Search: optimization ×Remove search](https://msaied.com/articles?sort=new) [ Clear filters](https://msaied.com/articles) 

  [![](https://cdn.msaied.com/795/9d9dd20c259ecc6356a91021a872695c.png)](https://msaied.com/articles/eloquent-query-optimization-defeating-n1-problems-at-the-source)18 Oct 2026·3 min read 

### [Eloquent Query Optimization: Defeating N+1 Problems at the Source](https://msaied.com/articles/eloquent-query-optimization-defeating-n1-problems-at-the-source) 

 N+1 queries silently destroy Laravel app performance. This guide shows you how to detect, fix, and prevent them using eager loading strategies, query counting in tests, and Eloquent relationship tuning.

   [![](https://cdn.msaied.com/523/a12bd8c82544aafcd6de50ff8c076141.png)](https://msaied.com/articles/eloquent-query-optimization-slaying-n1-problems-at-scale)8 Aug 2026·4 min read 

### [Eloquent Query Optimization: Slaying N+1 Problems at Scale](https://msaied.com/articles/eloquent-query-optimization-slaying-n1-problems-at-scale) 

 N+1 queries silently kill Laravel app performance. This guide digs into eager loading strategies, query deduplication, and Eloquent internals to help you write queries that stay fast as data grows.

   [![](https://cdn.msaied.com/475/39c5bf23764003ebc9ac32d840752d49.png)](https://msaied.com/articles/eloquent-query-optimization-killing-n1-problems-at-the-source)27 Jul 2026·3 min read 

### [Eloquent Query Optimization: Killing N+1 Problems at the Source](https://msaied.com/articles/eloquent-query-optimization-killing-n1-problems-at-the-source) 

 N+1 queries silently destroy Laravel app performance. This guide shows senior engineers how to detect, eliminate, and prevent them using eager loading strategies, query analysis, and Eloquent best practices.

   [![](https://cdn.msaied.com/327/a63b6cb7e6fa83812746015ccb2ee7b7.png)](https://msaied.com/articles/mysql-optimization-for-laravel-covering-indexes-explain-analyze-and-query-profiling)30 Jun 2026·4 min read 

### [MySQL Optimization for Laravel: Covering Indexes, EXPLAIN ANALYZE, and Query Profiling](https://msaied.com/articles/mysql-optimization-for-laravel-covering-indexes-explain-analyze-and-query-profiling) 

 Stop guessing why your Laravel app slows down under load. Learn how to read EXPLAIN ANALYZE output, build covering indexes, and profile slow queries with real Eloquent examples.

   [![](https://cdn.msaied.com/265/e97881aef9580e1f0b9e1bd6890d828a.png)](https://msaied.com/articles/mysql-explain-and-index-optimization-for-laravel-developers)22 Jun 2026·4 min read 

### [MySQL EXPLAIN and Index Optimization for Laravel Developers](https://msaied.com/articles/mysql-explain-and-index-optimization-for-laravel-developers) 

 Stop guessing why your Laravel queries are slow. Learn to read EXPLAIN output, spot full table scans, and design indexes that actually get used — with real Eloquent examples throughout.

  Have a technical challenge?
----------------------------

Tell me what you’re building. I reply within two working days.

 [Discuss your project ↗](https://msaied.com#contact) 

Topics
------

Close 

 [All topics](https://msaied.com/articles) [AI (48) ](https://msaied.com/articles?category=ai&search=optimization&sort=new) [Composer Pacakge (81) ](https://msaied.com/articles?category=composer-pacakge&search=optimization&sort=new) [Filament (27) ](https://msaied.com/articles?category=filament&search=optimization&sort=new) [Laravel (267) ](https://msaied.com/articles?category=laravel&search=optimization&sort=new) [Livewire (13) ](https://msaied.com/articles?category=livewire&search=optimization&sort=new) [Open Source (44) ](https://msaied.com/articles?category=open-source&search=optimization&sort=new) [PHP (27) ](https://msaied.com/articles?category=php&search=optimization&sort=new) [Tips &amp; Tricks (32) ](https://msaied.com/articles?category=tips-tricks&search=optimization&sort=new)  

  © 2026 Mohamed Said · Built with Laravel, meant to last.Senior Backend Engineer specializing in Laravel, scalable SaaS platforms, APIs, and cloud infrastructure. I build secure, high-performance web applications that help businesses grow.

 - [Home](https://msaied.com)
- [Articles](https://msaied.com/articles)
- [Certificates](https://msaied.com/certificates)
- [GitHub](https://github.com/EG-Mohamed)
- [LinkedIn](https://www.linkedin.com/in/msaiedm/)
- [WhatsApp](https://wa.me/201094619204)
- [Email Address](mailto:hello@msaied.com)
- [My CV](https://drive.google.com/file/u/0/d/1MF20IPRJyzfy32mhEutjL5EpSls0w2Q8/view)
- [Sitemap](https://msaied.com/sitemap.xml)
