Re: Faster way of retrieving the number of recs in mysql

Hi
Better to use select count(*) from table where <condition>
This is the fastest way possible. It will not overload your DB.
Thanks
Sasi Kumar

Comment on Re: Faster way of retrieving the number of recs in mysql Download Code

Replies are listed 'Best First'.
Re^2: Faster way of retrieving the number of recs in mysql by Thilosophy (Curate) on Dec 13, 2004 at 09:23 UTC
And unless necessary, omit the `where` clause. In MySQL, a `count(*)` can be answered just by querying the table meta data (VERY FAST), whereas conditions in the `where` clause will result in index or even table scans (ranging from NOT SO FAST to SLOW).	[reply]
Re^3: Faster way of retrieving the number of recs in mysql by Andre_br (Pilgrim) on Dec 14, 2004 at 00:15 UTC
In deed, that´s a great solution! It´s working just great now! Thanks a lot my friends!	[reply]