[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