From: Reindl Harald
Date: July 15 2011 8:23pm
Subject: Re: MySQL RAND() Issues [was Re: How to Shuffle data]
List-Archive: http://lists.mysql.com/mysql/225391
Message-Id: <4E20A1A8.8020700@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigF79B442B5C7476BD0F95B424"

--------------enigF79B442B5C7476BD0F95B424
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



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=3D59253
>=20
> 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


--------------enigF79B442B5C7476BD0F95B424
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk4goagACgkQhmBjz394Anl4DwCePY6ZxaOJSoM8KeYaeNDdHc0E
MMYAmgMkRg4wPFb+SpPS0mKpwqk19X7c
=tFUW
-----END PGP SIGNATURE-----

--------------enigF79B442B5C7476BD0F95B424--