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

[Markus Klein]

+1 by reading and testing.

Regards
Markus

> -----Original Message-----
> From: typo3-team-core-bounces at lists.typo3.org [mailto:typo3-team-core-
> bounces at lists.typo3.org] On Behalf Of Christian Kuhn
> Sent: Thursday, January 13, 2011 11:39 PM
> To: TYPO3 core team
> Subject: [TYPO3-core] RFC #16698: Optimize indexes on table sys_history
> 
> 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