Re: Why using username instead of user id?

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