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!