[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