[TYPO3-dev] Tip: use SQL function COUNT(*)

[Dmitry Dulepov [typo3]]

Hi!

Jigal van Hemert wrote:
> MyISAM can only use the internal counter if there is no WHERE, etc. 
> InnoDB has no internal record counter and is often much slower with 
> COUNT(*).

The SQL statements above were without WHERE. I answered that case.

-- 
Dmitry Dulepov
TYPO3 Core team
More about TYPO3: http://typo3bloke.net/
Subscribe: http://typo3bloke.net/rss.xml
Latest article: http://typo3bloke.net/post-details/nominate_me_as_typo3_mvp/