Archive
slow-query-log
-
EXPLAIN, and the report that took forty seconds
A finance report on the ERP took 41 seconds against 1.9 million invoices. The slow query log, EXPLAIN, one index that was never used, and the composite index that finally worked on MySQL 5.5.