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

Martin Kutschker Martin.Kutschker at n0spam-blackbox.net
Wed Mar 29 14:55:43 CEST 2006


Dmitry Dulepov schrieb:
> Hi!
> 
> Martin Kutschker wrote:
> 
>>Fine should we remove the "Using MySQl indexes effectively" section
>>then? Because the information is wrong. Randomly adding indices on
>>single fields improves nothing.
> 
> 
> It improves a bit but not as much as index on a number of fields. But
> this will be a task for core developers to analyze queries and propose
> better indexes.
> 
> I think current information about indexes should stay in wiki. It is not
> a "swiss army knife" but still useful.

I see really no point in those indices as it will probably never be used by 
TYPO3. Perhaps an index on (sorting,deleted,hidden) will make sense, but 
two indices on (deleted) and (hidden) are IMHO a wrong use of indices.

Masi




More information about the TYPO3-dev mailing list