Aside from the incredibly annoying fact that InnoDB tables don't store a
total COUNT(), my question is... Why are these numbers different? I could
easily parse out the second query which is REDICULOUSLY faster. BTW, why
doesn't mySQL just 'alias' the first query behind the scenes for us and
parse out the count?
mysql> SELECT COUNT(rsm_report_id) FROM Swordfish.rsm_reports;
+----------------------+
| COUNT(rsm_report_id) |
+----------------------+
| 277456 |
+----------------------+
1 row in set (24.84 sec)
mysql> show table status where Name = 'rsm_reports'\G
*************************** 1. row ***************************
Name: rsm_reports
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 296100 <<----- why doesn't this match above?!
Avg_row_length: 3204
Data_length: 948961280
Max_data_length: 0
Index_length: 13664256
Data_free: 0
Auto_increment: 277457 <<----- this can't be counted on
Create_time: 2007-03-26 20:23:14
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: InnoDB free: 5120 kB
1 row in set (0.27 sec)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
