Оптимизация вывода статистики в разделе людей.

[livestreet]

Оптимизация вывода статистики в разделе людей.

[vicgor]

А в мануале MySQL написано другое:

COUNT(*) is optimized to return very quickly if the SELECT retrieves from one table, no other columns are retrieved, and there is no WHERE clause. For example:

SELECT COUNT(*) FROM student;
This optimization applies only to MyISAM tables only, because an exact row count is stored for this storage engine and can be accessed very quickly. For transactional storage engines such as InnoDB, storing an exact row count is more problematic because multiple transactions may be occurring, each of which may affect the count.

[Xmk]

А в мануале MySQL написано другое:

Ну и написано, что данная оптимизация касается только MyISAM