Poor count() performance with MySQL compared to PostgreSQL with large JSON datasets
MySQL COUNT Function Explanation and Examples (2023)
MySQL -Improve slow query performance - Stack Overflow
Tobias_Petry.sql on Twitter: "⚡️ Database Tip There can be a faster way to group a table by multiple attributes compared to executing many queries. With GROUPING SETS the table needs only to
database performance - MySQL Extremely Large Table Size - Stack Overflow