NYCPHP Meetup

[Malcolm, Gary]

1. don't use count(*) because mysql will pull all fields for every record...
	use $result = mysql_query("SELECT count(col_name) FROM table_name");

2. db's are optimized for this query so their return is like greased
lightening :)

3. let the db do the work!


> -----Original Message-----
> From: Nasir Zubair [mailto:lists at ny-tech.net]
> Sent: Tuesday, 27 May, 2003 9:38 AM
> To: NYPHP Talk
> Subject: [nycphp-talk] mySQL optimization question.
> 
> 
> I was wondering if I have following two pieces of codes. 
> Which one is better
> and why.
>  
> 1:
>  
> $result = mysql_query("SELECT col_name FROM table_name");
> $count = mysql_num_rows($result);
>  
>  
> 2: 
>  
> $result = mysql_query("SELECT count(*) FROM table_name");
> list($count) = mysql_fetch_row($result);
>  
> I always though COUNT(*) was better than getting the rows and 
> counting them
> via PHP. I need to explain it to someone as to why or why not 
> count(*) is
> better than the other method.
>  
> Any comments?
>  
> - Nasir
> 
> 
> 
> --- Unsubscribe at http://nyphp.org/list/ ---
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20030527/ed3d6b8a/attachment.html>