Re: SQL COUNT vs mysql_num_rows
| From: | Boyan Nedkov | Date: | Thu, 06 Nov 2003 04:54:54 +0000 |
| Subject: | Re: SQL COUNT vs mysql_num_rows | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31468@lists.php.net to get a copy of this message | ||
if tables are joined correctly it shouldn't be any problem to get count of a column, and yes - delegating that task to the database should be more efficient concerning the execution time
boyan
--
margor777@yahoo.com wrote:
maybe mysql cannot COUNT the result from more than 1 table, hence the mysql_num_rows function - but isn't it good programming practice to get the SQL to do as much work up front? --------------------------------- Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard