Quote:
Originally Posted by xentek
MySQL count is probably faster, but not on star. Do it on your primary key field, and it should be faster.
|
Keep in mind this is only safe if the field you're counting on is 'not null'. Counting on fields skips null values.