[TYPO3-dev] strange enableFields SQL with T3 4.0

[Martin Kutschker]

Martin Schoenbeck schrieb:
>>
>>>>AND CONCAT(',', fe_group, ',') LIKE '%,2,%'
>>
>>As this SQL statement clearly simplifies the query and gains much more 
>>performance, one have to keep in mind that CONCAT is not ANSI-SQL and 
>>that e.g. Postgres doesn't about that function.
> 
> Why do you expect this statement to perform better than the original?
> AFAICS it also has no chance to use an index. Once the data is in memory it
> will not make a big difference whether you do a concatenation and one LIKE
> or three LIKE and a compare.

 > To better performance you'll have to find a
> method to evaluate without loading. Normalizing the data would do that.

Loading reading from disk? If so, normalizing won't speed things up. As 
you're doing a join even more records are read.

Masi