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/

созданный 22d | 12 мар. 2025 г., 19:10:03


Войдите, чтобы добавить комментарий

Другие сообщения в этой группе

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

4 апр. 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

1 апр. 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 мар. 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 мар. 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 мар. 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 мар. 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 мар. 2025 г., 22:10:06 | PHP Architect