mysql> show create table votes;
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                                                                                                                                         |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| votes | CREATE TABLE `votes` (
  `topentry` int(10) unsigned NOT NULL,
  `top` tinyint(1) unsigned DEFAULT NULL,
  `date` datetime NOT NULL,
  `account` varchar(32) NOT NULL,
  `amount` float DEFAULT NULL,
  `sent` tinyint(3) NOT NULL,
  UNIQUE KEY `topentry` (`topentry`,`top`,`date`,`account`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

mysql> show create table votes1;
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table  | Create Table                                                                                                                                                                                                                                                                                                                          |
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| votes1 | CREATE TABLE `votes1` (
  `topentry` int(10) unsigned NOT NULL,
  `top` tinyint(1) unsigned DEFAULT NULL,
  `date` datetime NOT NULL,
  `account` varchar(32) NOT NULL,
  `amount` float DEFAULT NULL,
  `sent` tinyint(3) NOT NULL,
  UNIQUE KEY `topentry` (`topentry`,`top`,`date`,`account`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select count(*) from votes;
+----------+
| count(*) |
+----------+
|   543802 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from votes1;
+----------+
| count(*) |
+----------+
|   543799 |
+----------+
1 row in set (0.00 sec)

mysql> select 1 from votes where sent=1 order by date desc limit 1;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (2.10 sec)

mysql> select 1 from votes1 where sent=1 order by date desc limit 1;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.09 sec)

mysql> select count(*) from votes where sent=1 order by date desc;
+----------+
| count(*) |
+----------+
|   543859 |
+----------+
1 row in set (1.99 sec)

mysql> select count(*) from votes1 where sent=1 order by date desc;
+----------+
| count(*) |
+----------+
|   543799 |
+----------+
1 row in set (0.15 sec)

mysql> select sql_no_cache count(*) from votes where sent=1 order by date desc; +----------+
| count(*) |
+----------+
|   543859 |
+----------+
1 row in set (1.65 sec)

mysql> select sql_no_cache count(*) from votes1 where sent=1 order by date desc;
+----------+
| count(*) |
+----------+
|   543799 |
+----------+
1 row in set (0.07 sec)