GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Speed up my mysql query please

escoman · 06-18-2010, 05:44 AM

SELECT *
FROM mytable
WHERE vonline = 'Y'
ORDER BY RAND( ) DESC
LIMIT 44

I need a good alternative to rand() that is fast. 0.01> or so.

06-18-2010, 05:44 AM
escoman Confirmed User Join Date: Jun 2004 Posts: 597	Speed up my mysql query please - order by rand() SELECT * FROM mytable WHERE vonline = 'Y' ORDER BY RAND( ) DESC LIMIT 44 I need a good alternative to rand() that is fast. 0.01> or so. __________________ Porn