Managing the RADIUS database

[Alexander Clouter]

Alan Buxey <A.L.M.Buxey at lboro.ac.uk> wrote:
> 
>> I guess I am a 'small cheese' with only 2m rows in my authentication 
>> table?  I am using PgSQL and have btree'd my timestamp columns, but it 
>> still takes only 3.6s to pull 10k rows worth of just todays data.
> 
> ah..you have the immediate advantage of postgreSQL
>
For me it's the CIDR syntax:

SELECT * FROM dot1x_auth WHERE nas_ip_address <<= 1.2.0.0/16

Cheers

-- 
Alexander Clouter
.sigmonster says: The price of greatness is responsibility.