MySQL Forums
Forum List  »  Optimizer & Parser

Re: count(*) versus mysql_num_rows
Posted by: Jacky Shu
Date: November 24, 2005 09:18AM

second one.
the first one returns all rows.
If the table is a myisam table, the second one is very efficient.

Options: ReplyQuote


Subject
Views
Written By
Posted
28138
November 21, 2005 03:54PM
Re: count(*) versus mysql_num_rows
7453
November 24, 2005 09:18AM
8065
June 02, 2006 04:13AM
5617
June 08, 2006 09:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.