Is it faster for the randomize the sort order of a large set of results on the MySQL server or after I have received the data in PHP?
Does anyone have any data to backup either side, or even anecdotal experience?
My educated guess is that MySQL wins hands down. It's made to handle data this way. The sheer overhead of having to move all the data over to PHP for sorting gives it an advantange to boot.
You can find out for yourself by doing some benchmarking, of course.
The content is written by members of the stackoverflow.com community.
It is licensed under cc-wiki