[TYPO3-core] RFC: performance improvemenets for database

[Ingmar Schlecht]

Ingmar Schlecht wrote:
> Dmitry Dulepov wrote:
>> +  KEY recordidentAS (tablename,recuid,tstamp)
> 
> What does the AS in recordidentAS stand for? Wouldn't it have been
> better to not use uppercase letters in any of the key names?

...and another comment:

When I go to Update Database in the Install Tool, it always suggests...

 	ALTER TABLE pages DROP KEY parent;
	ALTER TABLE pages ADD KEY parent (pid, sorting);
	ALTER TABLE tt_content DROP KEY parent;
	ALTER TABLE tt_content ADD KEY parent (pid, sorting);

...no matter how often I click "Write to database", it stays there.

cheers
Ingmar