Archive for 2月, 2009
Solution to replace MYSQL “ORDER BY RAND()”
星期一, 2月 23rd, 2009Some of you might be using the following directive to do Random Picking from your MYSQL database, which is mysql_query(”SELECT * FROM table ORDER BY RAND() LIMIT 10″);
However, It is not a good way if your website is in a high-flow-situation, Using such directive might causing a big loading in your hosting machine, here’s the [...]