[TYPO3-dev] Optimizing last 20 query
Steffen Müller
steffen at mail.kommwiss.fu-berlin.de
Fri Mar 16 01:10:45 CET 2007
>
> On 15.03.2007 21:16 John Angel wrote:
>>> I am not sure what SQL_NO_CACHE does, but it seems like non ANSI SQL?
>> It's just to avoid caching, usable for optimizing SQL statements.
>>
>
> optimize what?
> SQL_NO_CACHE turns off query cache. I don't see a benefit in turning it
> off. Quite the opposite: repeat your query and compare query duration.
>
ahh, now I got it: useable for debugging queries.
So late at night...
--
cheers,
Steffen
More information about the TYPO3-dev
mailing list