[TYPO3-core] RFC #16698: Optimize indexes on table sys_history

[Christian Kuhn]

This is an SVN patch request.

Type: performance improvement (minor)

BT: http://bugs.typo3.org/view.php?id=16698

Branches: trunk

Problem:
Indexes on sys_history are non optimal.

Solution:
Remove one key, add two new keys, convert table to InnoDB.

Notes:
See BT and related issue for discussion and affected queries.

Regards
Christian
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 16698_02.diff
Type: text/x-patch
Size: 544 bytes
Desc: not available
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20110113/55470aa6/attachment.bin>