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

Martin Kutschker masi-no at spam-typo3.org
Fri Jul 18 16:14:52 CEST 2008


ries van Twisk schrieb:
> 
> Also keep in mind that in some databases counting is much more expensive
> then counting in MySQL with MyISAM tables.

But I don't beleive that counting server side is more expensive than
client side for any DB.

But of course it doesn't make sense to do a COUNT(*) to decide if you
should do a full select with *exactly* the same WHERE statement. I've
seen that too. In this case the DB has to do the same work twice.

Masi





More information about the TYPO3-dev mailing list