Re: [PHP-DB] Which "select " is fast,thanks....... ?

2002-03-16 Thread Pierre-Alain Joye 

On Sat, 16 Mar 2002 23:03:48 +0800
±i®p»Ê <[EMAIL PROTECTED]> wrote:

> Hi,all friends:
> 
> Would you please tell me which script in MySQL is  fast?
> -
> 1.  select count(*) from  bk_data  
Never use * 
> 2.  select count(book_name) from bk_data
always specify fields you need. mysql does not have to look for fields definitions, 
and last but not least, your query will more readable :).

pa
  

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Which "select " is fast,thanks....... ?

2002-03-16 Thread 張峰銘 

Hi,all friends:

Would you please tell me which script in MySQL is  fast?
-
1.  select count(*) from  bk_data  

2.  select count(book_name) from bk_data

-

PS.  I have 13000 book records  in this table.

Fongming from Taiwan, thanks