How many up un a sql ip pool

[Alan DeKok]

On Dec 15, 2014, at 4:54 PM, Fabrizio Fiore Donati <fabrizio.fioredonati at 2bite.net> wrote:
> we have 3 pppoe access server, now i want to use a centralized ip pool via radius, can freeradius manage an ip pool of about 10000 ip via sql-ip pool ?

  Yes.   I’ve used it with 300K IPs.

  The issue is less the number of IPs than the rate of change.  With all of the queries necessary to manage IPs, SQL databases can typically do no more than 150 or so IP address assignments per second.  So if your system is under that limit, you’re fine.  If it’s over, you’ll have to come up with a different technique to improve performance.

  Alan DeKok.