I still don't see how running two queries is going to be faster than putting the count with a group by into one query.

I read that statement to mean that using count(*) is going to return the fastest answer as opposed to running count(some field name). Which I think doesn't imply that you should use 2 queries but you should use count(*) with the group by to achieve the fastest answer as opposed to doing two select statements.

(make any sense?)

[Edited by rangersfan on 08-10-2000 at 04:50 PM]