List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:July 15 2011 8:23pm
Subject:Re: MySQL RAND() Issues [was Re: How to Shuffle data]
View as plain text  

Am 15.07.2011 19:40, schrieb Jan Steinman:
>> From: Reindl Harald <h.reindl@stripped>
>>
>> do not use any random-functions of mysql even if they exists
>> http://bugs.mysql.com/bug.php?id=59253
> 
> So RAND() can be useful, but it is not really very random

the problem is the idiotic temp table
fecth a random record with it out of a tbale with
few thousand of records and pray to god that your
website has not much users because mysqld will
bring your machine down


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
MySQL RAND() Issues [was Re: How to Shuffle data]Jan Steinman15 Jul
  • Re: MySQL RAND() Issues [was Re: How to Shuffle data]Arthur Fuller15 Jul
    • Re: MySQL RAND() Issues [was Re: How to Shuffle data]Michael Dykman15 Jul
    • Re: MySQL RAND() Issues [was Re: How to Shuffle data]Dan Nelson15 Jul
  • Re: MySQL RAND() Issues [was Re: How to Shuffle data]Reindl Harald15 Jul