10-22-2009, 11:45 AM
|
| |
|
|
eXpert |
|
Join Date: Apr 2006
Posts: 339
|
|
|
Re: Optimize mysql query
Order by rand() is notorious for being slow on large tables.
http://www.webtrenches.com/post.cfm/avoid-rand-in-mysql
__________________
Version 4.1.8 & 4.1.9
ezcheckout4.1.x
cdseolinks2
product_metatags41x
shipping_per_product41x
http://www.earthsmagic.com
|
|
|