[TYPO3-dev] strange enableFields SQL with T3 4.0

[Martin Kutschker]

Martin Schoenbeck schrieb:
> 
>>If so, normalizing won't speed things up. As 
>>you're doing a join even more records are read.
> 
> Of course it would. You don't have to read any data to find the records for
> a join if you have prepared usable indexes.  But you can't prepare an index
> for the current situation.

So your statement is true for specific conditions. That's not bad as such. 
But IMHO you should specify the conditions that are necessary to gain a 
performance boost for something.

Summing up: to redeuce the number of disk reads for whole records the 
complete where clause of the query must be satisfied by an index.

This is IMHO not easy for the average query. But it can be set up for 
specific key queries of the application.

Masi