As documented in MySQL manual, getting something random on a SQL call is dozens, hundreds of times slower than a common 'ORDER BY'. They even suggest using the language you are using (php, j2ee, .net) to achieve your goal. http://dev.mysql.com/doc/refman/5.0/en/select.html#c2161
I'd like to know other solutions, inside cakephp, to this problem.. Which one is *the* solution.. should I care? cache that thing and live with it? :) Spark -- [livesets] http://djspark.com.br/ [web] http://sydi.net [filmes] http://melhoresfilmes.com.br --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
