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?