Why using username instead of user id?

[Morteza Milani]

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.

Regards,
Morteza Milani