Posted: Mon Apr 17, 2006 4:13 pm
But we are talking here about which is faster for counting the rows in a specific table. No wonder that you got these results... You calculated the time it took the script to select the rows as well.timvw wrote:My experiments show me that the combination of select and mysql_num_rows is faster than select and select count in that case...