3 ms·
I may be wrong here, but I think the difference is largely around how things are viewed differently between experts and non-experts. Experts understand that "e
by mcherm 13y ago
I may be wrong here, but I think the difference is largely around how things are viewed differently between experts and non-experts.
Experts understand that "estimate the number of rows" and "count the number of rows" are two different operations. They know that "count()" is supposed to count, not estimate and that in MySQL it does an estimate instead. They even know a simple way to provide quick estimates.
Non-experts know that "count()" is faster in one tool than another.
- copergi 13y agoCertainly, mysql's existence has always been based on "we're the db for people who don't know anything about dbs". But in this particular case, the person I responded to does know that mysql isn't doing a count, he pointed it out himself.