[TYPO3-dev] performace of cachingframework

Bjoern Pedersen bjoern.pedersen at frm2.tum.de
Mon Feb 21 15:11:33 CET 2011


Am 21.02.2011 14:47, schrieb Steffen Kamper:
> Hi,
> 
> Am 21.02.2011 14:40, schrieb Dmitry Dulepov:
>> Hi!
>>
>> Bjoern Pedersen wrote:
>>> a) we need an indexed expire column
>>
>> Generally a single index column is not worth unless it is the only one
>> used in WHERE. Everything depends on the query. It is best to see the
>> query and field definitions to decide on indexes.
>>
> 
> absolute correct. That makes it so difficult to find the best indexes
> for TYPO3 tables.
> 
> vg Steffen

I agree. Actually that's what I meant with indexed column.  See  also
the thread start for a slowlog based analysis.

Björn




More information about the TYPO3-dev mailing list