Re: SQL - RANDOM

Korgan wrote:

Hi, i would ask what is the best method for random select from database. I have table with 20k items.. - If i use ,,select * from table order by rand() limit 3", the query

    took 0.0524 sec ... its slightly enough

and as your table grows in size, it gets slower and slower. Try this: http://edrackham.com/featured/get-random-row-with-mysql-without-order-by-rand/ There are other suggestions out there too, search for "mysql don't use random()". -- Postgresql & php tutorials http://www.designmagick.com/