Re:Digg: 40x Performance Increase by Sorting in PHP Rather t...
by petercooper on Wednesday March 24, 2010 @02:34AM
(#1215125)
It did (though less total memory). Significantly, though, the memory use was ephemeral at the application server end. Do the collation, push to a memcache server, server, and die :-)
BTW, you were doing this to avoid using too much memory at the database, but by doing this (assuming it's PHP; you didn't say) you are loading the result set twice into webserver memory.
Obviously it worked for you, maybe the webserver had more free memory.