[TYPO3-core] RFC: improving index of sys_template

[Michael Stucki]

Hi Martin,

> Done in trunk.

Thanks. I agree that the change doesn't belong to the stable branch.

> 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.
> 
> # new
> create index record on sys_log (recuid,uid);

Did you commit these changes meanwhile? Before you do so, please commit a
patch, and make sure to add the table name above each chunk in a comment
(because it may be out of the 3-lines-context).

About this discussion in general: Please try again to not discuss too many
details on this list. In this situation it would have worked great to
discuss this on typo3-dev and come back with a solution after everybody
agrees to it. This would also solve the lack-of-feedback problems...

- michael
-- 
Use a newsreader! Check out
http://typo3.org/community/mailing-lists/use-a-news-reader/