[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