Hello,

Trying to keep the database and the application fast,
I´d like to clearify my mind about it.

1) Is a SELECT DISTINCT over 5,000 records a weight
    query? (Supposing it has about 20 different option the the
    DISTINCT key).

2) Is SELECT ORDER BY RAND() over 1,500 records
    a weight query?

I need to put these two queries in the first page of our site.
So, I´ve been worried if it can slow down our site in the
pics.

Thanks,
Ronan



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to