MySQL Archive

  • PHP: Randomizing a text file using PHP + MYSQL, quickly & efficient

    PHP: Randomizing a text file using PHP + MYSQL, quickly & efficient

    I had one person approach me recently about my previous blog entry, stating that you cannot process randomization quickly in MYSQL because SELECT * FROM tablename ORDER BY RAND()"; would take horribly long to process when you have a large amount of records stored in a database. This is very true! RAND() is very slow [...]

    Read More