Why using username instead of user id?
Alan Buxey
A.L.M.Buxey at lboro.ac.uk
Mon Jan 23 12:54:19 CET 2012
Hi,
> In freeradius sql modules, queries are based on username instead of
> user id. Is it anything related to performance or it went in this way
> without any decision?
>
> Using username has two problems:
>
> * updating a username, or deleting one needs querying at least three tables.
>
> * Comparing strings needs more time than comparing integers when fetching data.
umm, because in most cases, users have typed in usernames - if you tell the users
what their userid is, then sure, they could use that instead.... but thats
highly inflexible
alan
More information about the Freeradius-Devel
mailing list