[TYPO3-dev] Testing TYPO3 caching vs.[FE][pageCacheToExternalFiles]

Dmitry Dulepov typo3 at fm-world.ru
Thu Mar 30 11:32:59 CEST 2006


Hi!

Martin Kutschker wrote:
> To convince me you must show me an index and the explains for real-world
> selects of TYPO3 :-)

EXPLAIN is only a guess. It is not authorative and depends on the
current state of the database, number of records, "ANALYZE" status, etc.
I wouldn't trust it much. It gives good hints but nothing more.
Sometimes "USE INDEX" helps to increase performance a lot but it makes
SQL non portable...

Dmitry.
-- 
"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)




More information about the TYPO3-dev mailing list