[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