[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