[TYPO3-core] RFC: improving index of sys_template

[Dmitry Dulepov]

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.

> # new
> create index record on sys_log (recuid,uid);
> 
> The last index is only used in history/undo but avoids a scan of the 
> complete sys_log table (history has WHERE recuid=<id> SORT BY <uid>).

+1 too.

-- 
Dmitry Dulepov

Web: http://typo3bloke.net/
Skype: callto:liels_bugs

"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)