Hello everyone,
I have a quick question. Testing seems to indicate that Falcon keeps
accurate stats on the number of rows in a table. It appears similar to
the way MyISAM tables work. This can shown by running a 'SHOW TABLE
STATUS' command and comparing the number of rows with the SELECT
COUNT(*) command. Am I correct in this? Or have I not done enough tests?
Also, SELECT COUNT(*) appears to return a number of rows much quick than
a similar command on InnoDB tables. Again..similar to MyISAM. Am I
accurate in this?
thanks,
Keith
--
Editor
MySQL Magazine
http://www.mysqlzine.net
