[TYPO3-core] RFC: Feature Request #10091: Integrate TYPO3_DB->exec_SELECTcountRows()

Oliver Hader oliver at typo3.org
Sat Jan 10 16:09:49 CET 2009


Hi Steffen,

Steffen Kamper schrieb:
> Hi Olly,
> 
> Oliver Hader schrieb:
>> It's not required to implement this method also in DBAL since it's
>> available there and just uses methods that already got overridden if
>> DBAL is used.
> 
> where is it? I don't see function exec_SELECTcountRows in
> class.ux_t3lib_db.php

It's not required there since "ux_t3lib_DB extends t3lib_DB" and thus
it's available in DBAL context...

> On additional: It may be faster if using MySQL native counter
> SELECT SQL_CALC_FOUND_ROWS * FROM ...
> What do you think?

Hm, that works for MySQL but does not for Oracle. I don't know how other
DBMS behave here. COUNT(*) works on all DBMS...

olly
-- 
Oliver Hader
TYPO3 4.3 Release Manager


More information about the TYPO3-team-core mailing list