[TYPO3-dev] Optimizing last 20 query

Steffen Müller steffen at mail.kommwiss.fu-berlin.de
Fri Mar 16 01:07:32 CET 2007


Hi.

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.

-- 
cheers,
Steffen




More information about the TYPO3-dev mailing list