[TYPO3-mvc] ORDER BY RAND()

[Steffen Müller]

Hi Susanne,

On 14.03.2010 13:44 Susanne Moog wrote:
> 
> can I use extbase setOrderings to get an "ORDER BY RAND()" in the mysql
> query? As far as I have seen, this is currently not possible. Is it planned?
> 

This kind of query hurts performance badly.
http://www.mysqlperformanceblog.com/2006/09/01/order-by-limit-performance-optimization/
(also read the great commments of this article)


-- 
cheers,
Steffen

TYPO3 Blog: http://www.t3node.com/
Microblog:  http://twitter.com/t3node