Hi all,
I have a table with an auto incrementing primary key. I need to find the number of rows in that table. Is it better to do a
SELECT count(*)
or a
SELECT keyID FROM table ORDER BY keyID DESC LIMIT 1
and why is each better/worse than the alternative?
thanks,
-Phil
