[TYPO3-core] RFC: improving index of sys_template

[Martin Kutschker]

Dmitry Dulepov schrieb:
> Hi!
> 
>> After same investigation (using logged EXPLAIN during a session) I 
>> suggest the following indices:
>>
>> # changed
>> create index parent on pages (pid,sorting);
>> create index parent on tt_content (pid,sorting);
>>
>> The avoid a filesort for typical queries on pages and tt_content.
> 
> +1 since I use the same in some of my installations.

Any other ideas on improving the DB layout?

I know that you have also changed the table types. Do you think it is worth 
trying to make the installer/SQLparser deal with Mysql table types 
gracefully (eg it doesn't choke if Mysql doesn't support it for some reason).

Masi