Why using username instead of user id?

Morteza Milani fireboy.mrtz at gmail.com
Mon Jan 23 12:36:56 CET 2012

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.

Morteza Milani

More information about the Freeradius-Devel mailing list