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

[Allan Jacobsen]

Well, TYPO3 might not use the indices but Mysql will, and that will speed up your website.


Best regards/MVH
Allan Jacobsen
Infrastruktur, Dansk Tipstjeneste A/S
Korsdalsvej 135, 2605 Brøndby

-----Oprindelig meddelelse-----
Fra: typo3-dev-bounces at lists.netfielders.de [mailto:typo3-dev-bounces at lists.netfielders.de] På vegne af Martin Kutschker
Sendt: 29. marts 2006 14:56
Til: typo3-dev at lists.netfielders.de
Emne: Re: [TYPO3-dev] Testing TYPO3 caching vs.[FE][pageCacheToExternalFiles]

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
_______________________________________________
TYPO3-dev mailing list
TYPO3-dev at lists.netfielders.de
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev