This Week At PHP Architect: Optimizing A Query

This week, a client complained about a long-running query, and we needed to fix it. While I can’t divulge the actual query, I can give an idea of its nastiness, which we inherited when we took over the project. The query itself doesn’t matter, so don’t overanalyze it. Depending on the id’s used, this query […]

The post This Week At PHP Architect: Optimizing A Query appeared first on PHP Architect.

https://www.phparch.com/2025/03/this-week-at-php-architect-optimizing-a-query/

Établi 5mo | 12 mars 2025, 19:10:03


Connectez-vous pour ajouter un commentaire

Autres messages de ce groupe

Community Corner: Jacked PHP with Savio Resende

In this episode, we talk with Savio Resende about Open Swoole and Savio's book "Jacked PHP" which discusses how to get started using Open Swoole in your PHP projects. Links: "Jacked PHP" – h

12 août 2025, 16:40:03 | PHP Architect
Community Corner: Verbs with Daniel Coulbourne

In this episode, we talk with Daniel Coulbourne about the Verb library for Laravel, which provides an opinionated, user-friendly introduction to event sourcing. Links: Verbs Library – https:

8 août 2025, 22:20:05 | PHP Architect
PHP Podcast: 2025.08.07

The PHP Podcast streams the recording of this podcast live, typically every Thursday at 3 PM PT. Come join us and subscribe to our YouTube channel. X: https://x.com/phparch Mastodon: https://phpar

8 août 2025, 01:20:13 | PHP Architect
How PHP Really Reads Your Code (Abstract Syntax Tree (AST))

Do you ever wonder how PHP parses your code? Wonder no longer because in this video, Scott Keck-Warren from the PHP Architect Channel shows you how to inspect your code using the AST with the PHP-

5 août 2025, 17:40:07 | PHP Architect
The Psychology of a Developer

This month’s first feature article comes from Nelson Isioma, breaking down ‘Cool Things You Can Do With HTMX’. As Nelson discusses, HTMX brings additional functionality while usin

30 juil. 2025, 22:40:05 | PHP Architect
The PHP Podcast: 2025.07.24

This week on the PHP Podcast, Eric and John talk about Special guest Ben Ramsey, the PHP Community Discord, PHP Community Mastodon, Open Source Licenses, AI in companies and code, HHVM, and more&#

25 juil. 2025, 01:10:07 | PHP Architect
The PHP Podcast: 2025.07.17

This week on the PHP Podcast, Eric and John discuss Spec-driven Development with Kiro, JetBrains on Huggingface, Event Sourcing with Laravel Verbs, Automating your life with n8n, PHP Tek 2026 Webs

18 juil. 2025, 02:20:04 | PHP Architect