[TYPO3-dev] Typo3 Performance

[R. van Twisk]

Marc Wohlken [quadracom]" <woehlken at quadracom.de>" wrote:
> Dmitry Dulepov schrieb:
>   
>> So mysql will use either deleted or hidden index, he will not use both!
>> Much better will be:
>>
>> ALTER TABLE `be_groups` ADD INDEX (`deleted`, `hidden`)
>>     
>
>
> Totally agree, it's exactly what I suggested.
>
> Regards
> 	Marc
>
>   
It all depends of course, I think that typo3 can create queries rather 
dynamic.
sure making a compound key for hidden and deleted will help. Possible
adding other fields to the compound key will help aswell.

What we can do is create a a table that can store all executed queries 
and the time it took for execution,
and analyze this afterwards.

Ries

-- 
Ries van Twisk
Freelance Typo3 Developer
=== Private:
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/freelance-typo3.html
skype: callto://r.vantwisk