MySQL

Aggregating in SQL vs in memory: a Laravel dashboard performance lesson

Two chart methods in an old Laravel CRM — one aggregates counts in SQL, the one right below it loads every record into memory and sums them in a PHP closure. A dashboard performance lesson at millions of rows, and the junior-to-mid growth arc behind it.