alandekok/freeradius-server — Issue #44: Why using username instead of user id?
Author: milani
Created: 2012-01-23 11:13:47+00:00
State: open

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.