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

[Michael Knabe]

Am 21.07.2010 17:53, schrieb Oliver Klee:
> AFAIK this will even be faster if you use a COUNT(content) query instead
> of a SELECT query.
ACK, here's version 3 that uses COUNT(*) which is still a bit faster 
than COUNT(content).

I've attached an image that compares the different methods:
yellow is the original code
blue is COUNT(content)
red is COUNT(*)

Cheers,
Michael
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 15196.svg
Type: image/svg+xml
Size: 49656 bytes
Desc: not available
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100721/298ba892/attachment-0001.svg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 15196_v3.diff
Type: text/x-patch
Size: 857 bytes
Desc: not available
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100721/298ba892/attachment-0001.bin>