Thread
:
Optimize mysql query
View Single Post
#
10
10-27-2009, 02:59 AM
exsecror
X-Wizard
Join Date: Apr 2007
Posts: 1,284
Re: Optimize mysql query
The problem with that query is that RAND() is very poor on MySQL and LIMIT 20 only works AFTER MySQL has pulled down the entire table (due to the bad coding of their query analyzer on MySQL version prior to 6)
exsecror
View Public Profile
Find all posts by exsecror