On Wed, 2004-05-05 at 12:23, Chris wrote: > It's certainly faster than "SELECT COUNT(*) FROM sometable WHERE . . ."; > > It might not be faster than "SELECT COUNT(*) FROM sometable", as that is > designed to run very quickly.
I believe it will also depend on the type of table you are using. "SELECT COUNT(*) FROM sometable" is much faster with MyISAM tables than with InnoDB tables because InnoDB tables need to actually count all the rows where MyISAM tables keep that information handy. Someone please correct me if I got that wrong. - Brad -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
