Re:Digg: 40x Performance Increase by Sorting in PHP Rather t...
by nessence on Tuesday March 23, 2010 @08:40PM
(#1214530)
If the query cache, key buffer, sort buffer, and various engine configs are too small for the dataset then MySQL will take a less optimal approach. MySQL is an RDBMS for persistent data, not a spreadsheet...
"right tool for the job", etc.