在MySQL Server或PHP上将许多结果随机化的速度更快 [英] Faster to randomize many results on MySQL Server or in PHP

问题描述

在MySQL服务器上或在PHP中接收到数据后，将大量结果的排序顺序随机化是否更快?

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?

推荐答案

我的有根据的猜测是MySQL胜出.它是通过这种方式处理数据的.必须将所有数据移至PHP进行排序的庞大开销使它具有启动的优势.

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.

这篇关于在MySQL Server或PHP上将许多结果随机化的速度更快的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！