mysql> select count(*) from job; +----------+ | count(*) | +----------+ | 0 | +----------+ 1 row in set (0.46 sec)
mysql> explain select * from job; +-------+------+---------------+------+---------+------+------+-------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-------+------+---------------+------+---------+------+------+-------+ | job | ALL | NULL | NULL | NULL | NULL | 1080 | | +-------+------+---------------+------+---------+------+------+-------+ 1 row in set (0.37 sec)
Kinda sucks.
Kinda? That's a 100% error! MySQL's count() function is worse than I thought... how much less efficient is the accurate method? Could we cache the accurate value every 10 minutes or so and display that?