[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