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

[Steffen Kamper]

Hi,

Oliver Hader schrieb:
> 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

Wasn't it like
t3lib_db -> use native mysql functions
ux_t3lib_db -> use DBAL-compatible functions
? So it would be possible to differntiate

Masi: SQL_CALC_FOUND_ROWS is a keyword before field-definition, * was 
only for example.

vg Steffen