[TYPO3-core] RFC: No-brainer #15196: Speedup t3lib_cache_backend_DbBackend::has($entryIdentifier)

Oliver Klee typo3-german-02 at oliverklee.de
Wed Jul 21 17:53:25 CEST 2010


Hi,

Am 21.07.2010 16:23, schrieb Michael Knabe:
> Problem:
> t3lib_cache_backend_DbBackend::has($entryIdentifier) could be 50% faster
> using sql_num_rows instead of getRows/count

AFAIK this will even be faster if you use a COUNT(content) query instead
of a SELECT query.

Or you LIMIT the SELECT to 1 (if multiple matches are to be expected).

I haven't tested yet which of the two approaches is the fastest.


Oli
-- 
Certified TYPO3 Integrator | TYPO3 Security Team Member


More information about the TYPO3-team-core mailing list