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/

Erstellt 24d | 12.03.2025, 19:10:03


Melden Sie sich an, um einen Kommentar hinzuzufügen

Andere Beiträge in dieser Gruppe

The PHP Podcast: 2025.04.03

This week on the PHP Podcast, Eric and John talk about Laravel Wayfinder, PHP RFC Reviews, Bek shares why she attends PHP Tek, Free PHP Architect Column, and more… Links from the show: GitHub

04.04.2025, 02:30:07 | PHP Architect
Transforming PHP

This month’s feature examines ‘AI with PHP—Running pre-trained models with TransformersPHP’ by Vinicius Dias. AI’s popularity is at an all-time high and rising. New ad

01.04.2025, 00:20:06 | PHP Architect
PHP Architect Releases New Book: Jacked PHP

Jacked PHP aims to offer the developer tools to build better products. Since being faster and scalable is in high demand, looking for tools to support that becomes essential. With that in mind, we

31.03.2025, 17:20:12 | PHP Architect
The PHP Podcast: 2025.03.27

This week on the PHP Podcast, Eric and John talk about Laravel Cloud, Feature Flags, PHP Tek 2025, PHPxSan, and more… Links from the show: Laravel Cloud achieves SOC 2 Type 1 Compliance &#821

28.03.2025, 01:20:06 | PHP Architect
Automated Backups 101 with rsync

In this episode, Scott discusses why backups are important and uses #rsync to create an automated backup using #cron. PHP Tek is looking for sponsors! Contact see https://phptek.io/blog/elevate-you

27.03.2025, 04:30:02 | PHP Architect
Community Corner: Performance Psychology with Dr. Molly McQueary

In this episode, Scott talks with Dr. Molly McQueary, CMPC about Performance Psychology and Dr. McQueary’s talk at #phptek 2025. PHP Tek is looking for sponsors! Contact see https://phptek.io

27.03.2025, 02:10:06 | PHP Architect
Community Corner: DevRel With Tessa Kriesel

In this episode, Scott talks with Tessa Kriesel about #DevRel and her talk at #phptek 2025. PHP Tek is looking for sponsors! Contact see https://phptek.io/blog/elevate-your-brand-sponsorship-phptek

14.03.2025, 22:10:06 | PHP Architect