Why Count is faster in MyISAM engine in comparison to InnoDB engine??
I believe that is because the number of rows for MyISAM is cached, and hence may be inaccurate if the cache is accessed just before it is updated, whereas with InnoDB the rows are counted on the fly.
