[TYPO3-core] wrong inidices for fe_users

Dmitry Dulepov 9f4eetb02 at sneakemail.com
Mon Mar 12 13:00:21 CET 2007


Martin Kutschker wrote:
> Problem: the double key definition for parent(pid) and pid(pid,username) 
> is pointless. The latter key is sufficient and will be used even if 
> "username" is not used for sorting.
> 
> Solution: drop the key pid and add "username" to the key "parent"

+1.

We can also limit username to 20 chars or so to ensure index usage if 
there are too many records. What do you think?

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