Alan Buxey <[email protected]> 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. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
