I'm trying to do a count(*) in SQL. Would it be faster to do a or b below? a: just do a simple query, and use mysql_num_rows() to return the row count; or b: do the count(*) and use mysql_fetch_row() to return the result.
I guess it would have to do more with SQL response time (is it faster to grab the count and then the row, or all rows in question and then do a count in PHP).