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

in reply to Re: Faster way of retrieving the number of recs in mysql
in thread Faster way of retrieving the number of recs in mysql

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).

Comment on Re^2: Faster way of retrieving the number of recs in mysql

Replies are listed 'Best First'.
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]

In Section Seekers of Perl Wisdom