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