I am creating a script which will grab a random row from a mySQL table. Right now the way it is set up each time it calls COUNT(). I was thinking of creating a script and running it as a cron job to update count once every 10 minutes and store the number as an indexed array in the table. It seems like a lot of trouble, so how much overhead does COUNT have?
Thanks in Advance, Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]