How to set multiple reply values via a single SQL query?
aland at deployingradius.com
Tue Mar 3 21:22:46 CET 2015
On Mar 3, 2015, at 3:14 PM, James Wood <james.wood at purplewifi.net> wrote:
> Is there any way to set multiple reply items via a single SQL query?
No. Arran and I have discussed that. We have some ideas, but nothing final.
> At the moment, I have a table called settings and within that I have a
> number of columns like Session-Timeout. I am having to do multiple SQL
> queries to pull these out, even though they are in the same table, which is
> both introducing time and load on the server
The the short term you can select 3 fields, and use SQL to concatenate them as strings. Then, use FreeRADIUS to split the string.
Ugly, but less load for your SQL server.
More information about the Freeradius-Users