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

[Martin Kutschker]

Marc Wohlken [quadracom]" <woehlken at quadracom.de>" schrieb:
> 
> A compund index does only make sense if the included columns are really
> used together. This SHOULD be the case with "hidden" and "deleted" as
> these are some of the crucial columns for enableFields().

This is why I have suggested such an index.

> If someone uses a compund index (hidden, deleted) that would only
> increase db performance when a sql query contains
> 1) hidden and deleted
> 2) only hidden
> 
> In case of queries containing deleted only there would be no positive
> effect.

> BTW: Does anyone know how to build indexes for starttime and endtime
> columns? Probably a simple 4 Byte index is not optimal as it does not
> provide any grouping of values.

They will never be used alone.

In fact I even doubt if an index on "deleted" makes any sense. It is not 
used for sorting and the whole record must be fetched anyway.

Masi