[TYPO3-core] RFC: improving index of sys_template

[Martin Kutschker]

Dmitry Dulepov schrieb:
> 
> Indexed search updates and select is a nightmare. Searches sometimes 
> take from 30 seconds to several minutes. I tried investigating and 
> adjusting indexes there but with no luck.

Did you use only "LIKE 'begin%'" or also "LIKE '%contains%'" searches? 
While the whole set of queries are rather complex in indexed search * I see 
no way to make a "LIKE '%contains%'" go any faster as it will never use an 
index.

Masi

* The option processing and query generating is far from easy to read..