[TYPO3-core] RFC: improving index of sys_template

Dmitry Dulepov dmitry at typo3.org
Thu Oct 12 08:16:54 CEST 2006


> 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.)

More information about the TYPO3-team-core mailing list